ExecuteAutomation Database Server

This MCP (Model Context Protocol) server provides database access capabilities to Claude, supporting SQLite, SQL Server, PostgreSQL, and MySQL databases.

git clone https://github.com/executeautomation/mcp-database-server.git cd mcp-database-server

There are two ways to use this MCP server with Claude:
- Direct usage: Install the package globally and use it directly
- Local development: Run from your local development environment

The easiest way to use this MCP server is by installing it globally:

npm install -g @executeautomation/database-server

This allows you to use the server directly without building it locally.

If you want to modify the code or run from your local environment:
- Clone and build the repository as shown in the Installation section
- Run the server using the commands in the Usage section below

node dist/src/index.js /path/to/your/database.db

node dist/src/index.js --sqlserver --server <server-name> --database <database-name> [--user <username> --password <password>]

- --server: SQL Server host name or IP address
- --database: Name of the database

- --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)

node dist/src/index.js --postgresql --host <host-name> --database <database-name> [--user <username> --password <password>]

- --host: PostgreSQL host name or IP address
- --database: Name of the database

- --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)

node dist/src/index.js --mysql --host <host-name> --database <database-name> --port <port> [--user <username> --password <password>]

- --host: MySQL host name or IP address
- --database: Name of the database
- --port: Port number (default: 3306)

- --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)

For Amazon RDS MySQL instances with IAM database authentication:

- 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=myprofileenvironment variable
- AWS_ACCESS_KEY_IDandAWS_SECRET_ACCESS_KEYenvironment 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>

- --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

If you installed the package globally, configure Claude Desktop with:

{ "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" ] }, "mysql": { "command": "npx", "args": [ "-y", "@executeautomation/database-server", "--mysql", "--host", "your-host-name", "--database", "your-database-name", "--port", "3306", "--user", "your-username", "--password", "your-password" ] }, "mysql-aws": { "command": "npx", "args": [ "-y", "@executeautomation/database-server", "--mysql", "--aws-iam-auth", "--host", "your-rds-endpoint.region.rds.amazonaws.com", "--database", "your-database-name", "--user", "your-aws-username", "--aws-region", "us-east-1" ] } } }

For local development, configure Claude Desktop to use your locally built version:

{ "mcpServers": { "sqlite": { "command": "node", "args": [ "/absolute/path/to/mcp-database-server/dist/src/index.js", "/path/to/your/database.db" ] }, "sqlserver": { "command": "node", "args": [ "/absolute/path/to/mcp-database-server/dist/src/index.js", "--sqlserver", "--server", "your-server-name", "--database", "your-database-name", "--user", "your-username", "--password", "your-password" ] }, "postgresql": { "command": "node", "args": [ "/absolute/path/to/mcp-database-server/dist/src/index.js", "--postgresql", "--host", "your-host-name", "--database", "your-database-name", "--user", "your-username", "--password", "your-password" ] }, "mysql": { "command": "node", "args": [ "/absolute/path/to/mcp-database-server/dist/src/index.js", "--mysql", "--host", "your-host-name", "--database", "your-database-name", "--port", "3306", "--user", "your-username", "--password", "your-password" ] }, "mysql-aws": { "command": "node", "args": [ "/absolute/path/to/mcp-database-server/dist/src/index.js", "--mysql", "--aws-iam-auth", "--host", "your-rds-endpoint.region.rds.amazonaws.com", "--database", "your-database-name", "--user", "your-aws-username", "--aws-region", "us-east-1" ] } } }

The Claude Desktop configuration file is typically located at:

- macOS:~/Library/Application Support/Claude/claude_desktop_config.json
- Windows:%APPDATA%\Claude\claude_desktop_config.json
- Linux:~/.config/Claude/claude_desktop_config.json

The MCP Database Server provides the following tools that Claude can use:

For practical examples of how to use these tools with Claude, seeUsage Examples.

- SQL Server Setup Guide: Details on connecting to SQL Server databases
- PostgreSQL Setup Guide: Details on connecting to PostgreSQL databases
- Usage Examples: Example queries and commands to use with Claude

Interact with PostgreSQL, MySQL, MariaDB, and SQLite databases using SQLAlchemy.