executeautomation/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:
2. Install dependencies:
3. Build the project:
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:
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:
SQL Server Database
To use with a SQL Server database:
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:
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:
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)
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:
Local Development Configuration