{"_id":"@aegonnn/ea-database-server","_rev":"2-7e651c69f3207516333e3a4c37809344","name":"@aegonnn/ea-database-server","dist-tags":{"latest":"1.0.1"},"versions":{"1.0.0":{"name":"@aegonnn/ea-database-server","version":"1.0.0","author":{"name":"aegonnn"},"license":"MIT","_id":"@aegonnn/ea-database-server@1.0.0","maintainers":[{"name":"aegonnn","email":"zzzkamehamehazzz@gmail.com"}],"homepage":"https://github.com/executeautomation/mcp-database-server","bugs":{"url":"https://github.com/executeautomation/database-server/issues"},"bin":{"ea-database-server":"dist/src/index.js"},"dist":{"shasum":"a94daadafe914d8d474391cf2307a57ac35ee513","tarball":"https://registry.npmjs.org/@aegonnn/ea-database-server/-/ea-database-server-1.0.0.tgz","fileCount":16,"integrity":"sha512-/eUHGvW+r/aN0wTe1S25hqmINRam5I8wc2i9lrNj0zVUDWy3xZoBqXbOCIlI/HllhVHcgaHCO6uByrmSl9AE8Q==","signatures":[{"sig":"MEYCIQCPZNz53loZa02ZdG1YE6KI7B8cv+kyTEC/gJGTNQN1qQIhAOIbhv4AQY4pGljIeoh5ErvwkfseyqLu0yyYfnoTlMe4","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":68234},"type":"module","scripts":{"dev":"tsc && node dist/src/index.js","build":"tsc && shx chmod +x dist/src/index.js","clean":"rimraf dist","start":"node dist/src/index.js","watch":"tsc --watch","example":"node examples/example.js","prepare":"npm run build"},"_npmUser":{"name":"aegonnn","email":"zzzkamehamehazzz@gmail.com"},"_npmVersion":"11.6.1","description":"MCP server for interacting with SQLite and SQL Server databases (Forked)","directories":{},"_nodeVersion":"24.11.0","dependencies":{"pg":"^8.11.3","mssql":"11.0.1","mysql2":"^3.14.1","sqlite3":"5.1.7","@aws-sdk/rds-signer":"^3.0.0","@modelcontextprotocol/sdk":"1.9.0"},"_hasShrinkwrap":false,"devDependencies":{"shx":"0.4.0","rimraf":"^5.0.5","@types/pg":"^8.11.13","typescript":"5.8.3","@types/mssql":"^9.1.5","@types/sqlite3":"5.1.0"},"_npmOperationalInternal":{"tmp":"tmp/ea-database-server_1.0.0_1764306877042_0.025159950187282787","host":"s3://npm-registry-packages-npm-production"}},"1.0.1":{"name":"@aegonnn/ea-database-server","version":"1.0.1","description":"MCP server for interacting with SQLite and SQL Server databases (Forked)","license":"MIT","author":{"name":"aegonnn"},"homepage":"https://github.com/executeautomation/mcp-database-server","bugs":{"url":"https://github.com/executeautomation/database-server/issues"},"type":"module","bin":{"ea-database-server":"dist/src/index.js"},"scripts":{"build":"tsc && shx chmod +x dist/src/index.js","prepare":"npm run build","watch":"tsc --watch","start":"node dist/src/index.js","dev":"tsc && node dist/src/index.js","example":"node examples/example.js","clean":"rimraf dist"},"dependencies":{"@aws-sdk/rds-signer":"^3.0.0","@modelcontextprotocol/sdk":"1.9.0","mssql":"11.0.1","mysql2":"^3.14.1","pg":"^8.11.3","sqlite3":"5.1.7"},"devDependencies":{"@types/mssql":"^9.1.5","@types/pg":"^8.11.13","@types/sqlite3":"5.1.0","rimraf":"^5.0.5","shx":"0.4.0","typescript":"5.8.3"},"_id":"@aegonnn/ea-database-server@1.0.1","_nodeVersion":"24.11.0","_npmVersion":"11.6.1","dist":{"integrity":"sha512-qo7SHlqVg2kjKlk9OgZFlvD1NzcGlwDPhC6CmikRo70pT6XBqnqYZ5G4ij0zWPub0Vb+hScTK5QzzcCqHb4X7w==","shasum":"bc8bfd9ea0c8e8c9e552efde9dc1926d76b74879","tarball":"https://registry.npmjs.org/@aegonnn/ea-database-server/-/ea-database-server-1.0.1.tgz","fileCount":16,"unpackedSize":68235,"signatures":[{"keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U","sig":"MEQCIC9UhiOQcyJhe2z4Z8UFHTq7PyUgWABXAx74SSNCM0lnAiAEIGP1yI7k/5A6KG22vqNpvyogqhQLijsmEnesd83qiQ=="}]},"_npmUser":{"name":"aegonnn","email":"zzzkamehamehazzz@gmail.com"},"directories":{},"maintainers":[{"name":"aegonnn","email":"zzzkamehamehazzz@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages-npm-production","tmp":"tmp/ea-database-server_1.0.1_1764307423973_0.8683686139720601"},"_hasShrinkwrap":false}},"time":{"created":"2025-11-28T05:14:36.988Z","modified":"2025-11-28T05:23:44.389Z","1.0.0":"2025-11-28T05:14:37.243Z","1.0.1":"2025-11-28T05:23:44.185Z"},"bugs":{"url":"https://github.com/executeautomation/database-server/issues"},"author":{"name":"aegonnn"},"license":"MIT","homepage":"https://github.com/executeautomation/mcp-database-server","description":"MCP server for interacting with SQLite and SQL Server databases (Forked)","maintainers":[{"name":"aegonnn","email":"zzzkamehamehazzz@gmail.com"}],"readme":"[![MseeP.ai Security Assessment Badge](https://mseep.net/pr/executeautomation-mcp-database-server-badge.png)](https://mseep.ai/app/executeautomation-mcp-database-server)\n\n# MCP Database Server\n\nThis MCP (Model Context Protocol) server provides database access capabilities to Claude, supporting SQLite, SQL Server, PostgreSQL, and MySQL databases.\n\n## Installation\n\n1. Clone the repository:\n```\ngit clone https://github.com/executeautomation/mcp-database-server.git\ncd mcp-database-server\n```\n\n2. Install dependencies:\n```\nnpm install\n```\n\n3. Build the project:\n```\nnpm run build\n```\n\n## Usage Options\n\nThere are two ways to use this MCP server with Claude:\n\n1. **Direct usage**: Install the package globally and use it directly\n2. **Local development**: Run from your local development environment\n\n### Direct Usage with NPM Package\n\nThe easiest way to use this MCP server is by installing it globally:\n\n```bash\nnpm install -g @executeautomation/database-server\n```\n\nThis allows you to use the server directly without building it locally.\n\n### Local Development Setup\n\nIf you want to modify the code or run from your local environment:\n\n1. Clone and build the repository as shown in the Installation section\n2. Run the server using the commands in the Usage section below\n\n## Usage\n\n### SQLite Database\n\nTo use with an SQLite database:\n\n```\nnode dist/src/index.js /path/to/your/database.db\n```\n\n### SQL Server Database\n\nTo use with a SQL Server database:\n\n```\nnode dist/src/index.js --sqlserver --server <server-name> --database <database-name> [--user <username> --password <password>]\n```\n\nRequired parameters:\n- `--server`: SQL Server host name or IP address\n- `--database`: Name of the database\n\nOptional parameters:\n- `--user`: Username for SQL Server authentication (if not provided, Windows Authentication will be used)\n- `--password`: Password for SQL Server authentication\n- `--port`: Port number (default: 1433)\n\n### PostgreSQL Database\n\nTo use with a PostgreSQL database:\n\n```\nnode dist/src/index.js --postgresql --host <host-name> --database <database-name> [--user <username> --password <password>]\n```\n\nRequired parameters:\n- `--host`: PostgreSQL host name or IP address\n- `--database`: Name of the database\n\nOptional parameters:\n- `--user`: Username for PostgreSQL authentication\n- `--password`: Password for PostgreSQL authentication\n- `--port`: Port number (default: 5432)\n- `--ssl`: Enable SSL connection (true/false)\n- `--connection-timeout`: Connection timeout in milliseconds (default: 30000)\n\n### MySQL Database\n\n#### Standard Authentication\n\nTo use with a MySQL database:\n\n```\nnode dist/src/index.js --mysql --host <host-name> --database <database-name> --port <port> [--user <username> --password <password>]\n```\n\nRequired parameters:\n- `--host`: MySQL host name or IP address\n- `--database`: Name of the database\n- `--port`: Port number (default: 3306)\n\nOptional parameters:\n- `--user`: Username for MySQL authentication\n- `--password`: Password for MySQL authentication\n- `--ssl`: Enable SSL connection (true/false or object)\n- `--connection-timeout`: Connection timeout in milliseconds (default: 30000)\n\n#### AWS IAM Authentication\n\nFor Amazon RDS MySQL instances with IAM database authentication:\n\n**Prerequisites:**\n- AWS credentials must be configured (the RDS Signer uses the default credential provider chain)\n- Configure using one of these methods:\n  - `aws configure` (uses default profile)\n  - `AWS_PROFILE=myprofile` environment variable\n  - `AWS_ACCESS_KEY_ID` and `AWS_SECRET_ACCESS_KEY` environment variables\n  - IAM roles (if running on EC2)\n\n```\nnode dist/src/index.js --mysql --aws-iam-auth --host <rds-endpoint> --database <database-name> --user <aws-username> --aws-region <region>\n```\n\nRequired parameters:\n- `--host`: RDS endpoint hostname\n- `--database`: Name of the database\n- `--aws-iam-auth`: Enable AWS IAM authentication\n- `--user`: AWS IAM username (also the database user)\n- `--aws-region`: AWS region where RDS instance is located\n\nNote: SSL is automatically enabled for AWS IAM authentication\n\n## Configuring Claude Desktop\n\n### Direct Usage Configuration\n\nIf you installed the package globally, configure Claude Desktop with:\n\n```json\n{\n  \"mcpServers\": {\n    \"sqlite\": {\n      \"command\": \"npx\",\n      \"args\": [\n        \"-y\",\n        \"@executeautomation/database-server\",\n        \"/path/to/your/database.db\"\n      ]\n    },\n    \"sqlserver\": {\n      \"command\": \"npx\",\n      \"args\": [\n        \"-y\",\n        \"@executeautomation/database-server\",\n        \"--sqlserver\",\n        \"--server\", \"your-server-name\",\n        \"--database\", \"your-database-name\",\n        \"--user\", \"your-username\",\n        \"--password\", \"your-password\"\n      ]\n    },\n    \"postgresql\": {\n      \"command\": \"npx\",\n      \"args\": [\n        \"-y\",\n        \"@executeautomation/database-server\",\n        \"--postgresql\",\n        \"--host\", \"your-host-name\",\n        \"--database\", \"your-database-name\",\n        \"--user\", \"your-username\",\n        \"--password\", \"your-password\"\n      ]\n    },\n    \"mysql\": {\n      \"command\": \"npx\",\n      \"args\": [\n        \"-y\",\n        \"@executeautomation/database-server\",\n        \"--mysql\",\n        \"--host\", \"your-host-name\",\n        \"--database\", \"your-database-name\",\n        \"--port\", \"3306\",\n        \"--user\", \"your-username\",\n        \"--password\", \"your-password\"\n      ]\n    },\n    \"mysql-aws\": {\n      \"command\": \"npx\",\n      \"args\": [\n        \"-y\",\n        \"@executeautomation/database-server\",\n        \"--mysql\",\n        \"--aws-iam-auth\",\n        \"--host\", \"your-rds-endpoint.region.rds.amazonaws.com\",\n        \"--database\", \"your-database-name\",\n        \"--user\", \"your-aws-username\",\n        \"--aws-region\", \"us-east-1\"\n      ]\n    }\n  }\n}\n```\n\n### Local Development Configuration\n\nFor local development, configure Claude Desktop to use your locally built version:\n\n```json\n{\n  \"mcpServers\": {\n    \"sqlite\": {\n      \"command\": \"node\",\n      \"args\": [\n        \"/absolute/path/to/mcp-database-server/dist/src/index.js\", \n        \"/path/to/your/database.db\"\n      ]\n    },\n    \"sqlserver\": {\n      \"command\": \"node\",\n      \"args\": [\n        \"/absolute/path/to/mcp-database-server/dist/src/index.js\",\n        \"--sqlserver\",\n        \"--server\", \"your-server-name\",\n        \"--database\", \"your-database-name\",\n        \"--user\", \"your-username\",\n        \"--password\", \"your-password\"\n      ]\n    },\n    \"postgresql\": {\n      \"command\": \"node\",\n      \"args\": [\n        \"/absolute/path/to/mcp-database-server/dist/src/index.js\",\n        \"--postgresql\",\n        \"--host\", \"your-host-name\",\n        \"--database\", \"your-database-name\",\n        \"--user\", \"your-username\",\n        \"--password\", \"your-password\"\n      ]\n    },\n    \"mysql\": {\n      \"command\": \"node\",\n      \"args\": [\n        \"/absolute/path/to/mcp-database-server/dist/src/index.js\",\n        \"--mysql\",\n        \"--host\", \"your-host-name\",\n        \"--database\", \"your-database-name\",\n        \"--port\", \"3306\",\n        \"--user\", \"your-username\",\n        \"--password\", \"your-password\"\n      ]\n    },\n    \"mysql-aws\": {\n      \"command\": \"node\",\n      \"args\": [\n        \"/absolute/path/to/mcp-database-server/dist/src/index.js\",\n        \"--mysql\",\n        \"--aws-iam-auth\",\n        \"--host\", \"your-rds-endpoint.region.rds.amazonaws.com\",\n        \"--database\", \"your-database-name\",\n        \"--user\", \"your-aws-username\",\n        \"--aws-region\", \"us-east-1\"\n      ]\n    }\n  }\n}\n```\n\nThe Claude Desktop configuration file is typically located at:\n- macOS: `~/Library/Application Support/Claude/claude_desktop_config.json`\n- Windows: `%APPDATA%\\Claude\\claude_desktop_config.json`\n- Linux: `~/.config/Claude/claude_desktop_config.json`\n\n## Available Database Tools\n\nThe MCP Database Server provides the following tools that Claude can use:\n\n| Tool | Description | Required Parameters |\n|------|-------------|---------------------|\n| `read_query` | Execute SELECT queries to read data | `query`: SQL SELECT statement |\n| `write_query` | Execute INSERT, UPDATE, or DELETE queries | `query`: SQL modification statement |\n| `create_table` | Create new tables in the database | `query`: CREATE TABLE statement |\n| `alter_table` | Modify existing table schema | `query`: ALTER TABLE statement |\n| `drop_table` | Remove a table from the database | `table_name`: Name of table<br>`confirm`: Safety flag (must be true) |\n| `list_tables` | Get a list of all tables | None |\n| `describe_table` | View schema information for a table | `table_name`: Name of table |\n| `export_query` | Export query results as CSV/JSON | `query`: SQL SELECT statement<br>`format`: \"csv\" or \"json\" |\n| `append_insight` | Add a business insight to memo | `insight`: Text of insight |\n| `list_insights` | List all business insights | None |\n\nFor practical examples of how to use these tools with Claude, see [Usage Examples](docs/usage-examples.md).\n\n## Additional Documentation\n\n- [SQL Server Setup Guide](docs/sql-server-setup.md): Details on connecting to SQL Server databases\n- [PostgreSQL Setup Guide](docs/postgresql-setup.md): Details on connecting to PostgreSQL databases\n- [Usage Examples](docs/usage-examples.md): Example queries and commands to use with Claude\n\n## Development\n\nTo run the server in development mode:\n\n```\nnpm run dev\n```\n\nTo watch for changes during development:\n\n```\nnpm run watch\n```\n\n## Requirements\n\n- Node.js 18+\n- For SQL Server connectivity: SQL Server 2012 or later\n- For PostgreSQL connectivity: PostgreSQL 9.5 or later\n\n## License\n\nMIT\n","readmeFilename":"readme.md"}