mcp-database-server

[](https://mseep.ai/app/executeautomation-mcp-database-server) # MCP Database Server This MCP (Model Context Protocol) server provides database access capabilities to Claude, supporting SQLite, SQL Server, PostgreSQL, and MySQL databases. ## Installation 1. Clone the repository: ``` git clone https://github.com/executeautomation/mcp-database-server.git cd mcp-database-server ``` 2. Install dependencies: ``` npm install ``` 3. Build the project: ``` npm run build ``` ## Usage Options There are two ways to use this MCP server with Claude: 1. **Direct usage**: Install the package globally and use it directly 2. **Local development**: Run from your local development environment ### Direct Usage with NPM Package The easiest way to use this MCP server is by installing it globally: ```bash npm install -g @executeautomation/database-server ``` This allows you to use the server directly without building it locally. ### Local Development Setup If you want to modify the code or run from your local environment: 1. Clone and build the repository as shown in the Installation section 2. Run the server using the commands in the Usage section below ## Usage ### SQLite Database To use with an SQLite database: ``` node dist/src/index.js /path/to/your/database.db ``` ### SQL Server Database To use with a SQL Server database: ``` node dist/src/index.js --sqlserver --server <server-name> --database <database-name> [--user <username> --password <password>] ``` Required parameters: - `--server`: SQL Server host name or IP address - `--database`: Name of the database Optional parameters: - `--user`: Username for SQL Server authentication (if not provided, Windows Authentication will be used) - `--password`: Password for SQL Server authentication - `--port`: Port number (default: 1433) ### PostgreSQL Database To use with a PostgreSQL database: ``` node dist/src/index.js --postgresql --host <host-name> --database <database-name> [--user <username> --password <password>] ``` Required parameters: - `--host`: PostgreSQL host name or IP address - `--database`: Name of the database Optional parameters: - `--user`: Username for PostgreSQL authentication - `--password`: Password for PostgreSQL authentication - `--port`: Port number (default: 5432) - `--ssl`: Enable SSL connection (true/false) - `--connection-timeout`: Connection timeout in milliseconds (default: 30000) ### MySQL Database #### Standard Authentication To use with a MySQL database: ``` node dist/src/index.js --mysql --host <host-name> --database <database-name> --port <port> [--user <username> --password <password>] ``` Required parameters: - `--host`: MySQL host name or IP address - `--database`: Name of the database - `--port`: Port number (default: 3306) Optional parameters: - `--user`: Username for MySQL authentication - `--password`: Password for MySQL authentication - `--ssl`: Enable SSL connection (true/false or object) - `--connection-timeout`: Connection timeout in milliseconds (default: 30000) #### AWS IAM Authentication For Amazon RDS MySQL instances with IAM database authentication: **Prerequisites:** - AWS credentials must be configured (the RDS Signer uses the default credential provider chain) - Configure using one of these methods: - `aws configure` (uses default profile) - `AWS_PROFILE=myprofile` environment variable - `AWS_ACCESS_KEY_ID` and `AWS_SECRET_ACCESS_KEY` environment variables - IAM roles (if running on EC2) ``` node dist/src/index.js --mysql --aws-iam-auth --host <rds-endpoint> --database <database-name> --user <aws-username> --aws-region <region> ``` Required parameters: - `--host`: RDS endpoint hostname - `--database`: Name of the database - `--aws-iam-auth`: Enable AWS IAM authentication - `--user`: AWS IAM username (also the database user) - `--aws-region`: AWS region where RDS instance is located Note: SSL is automatically enabled for AWS IAM authentication ## Configuring Claude Desktop ### Direct Usage Configuration If you installed the package globally, configure Claude Desktop with: ```json { "mcpServers": { "sqlite": { "command": "npx", "args": [ "-y", "@executeautomation/database-server", "/path/to/your/database.db" ] }, "sqlserver": { "command": "npx", "args": [ "-y", "@executeautomation/database-server", "--sqlserver", "--server", "your-server-name", "--database", "your-database-name", "--user", "your-username", "--password", "your-password" ] }, "postgresql": { "command": "npx", "args": [ "-y", "@executeautomation/database-server", "--postgresql", "--host", "your-host-name", "--database", "your-database-name", "--user", "your-username", "--password", "your-password" ]