MCP Database Server

Community

MCP server that provides database access to Claude for SQLite, SQL Server, PostgreSQL, and MySQL

How to install ↓ Compare GitHub source repository ↗

Category: Database #25 of 58
Stars: ★ 386 Popular
Transport: stdio (local process)
Runtime: Node.js 18+
Credentials: Optional API key
License: MIT
Last commit: 14 months ago ⚠
Tools: 10

57FMRS · C

This server provides a rich set of database operation tools, covering multiple database types with flexible configuration. However, users need to be cautious with write operations and credential security.

Strongest · Documentation 15/20 Weakest · Security and permissions 8/20

Reliability

10/20

Security and permissions

8/20

Maintenance

12/20

Documentation

15/20

Setup experience

12/20

Why each score

Reliability 10/20: Based on the README, the server supports multiple databases and clearly specifies startup parameters. However, no tests or CI configuration files (e.g., GitHub Actions) were found in the repository, and there is no evidence that the initialization handshake and tool list have been actually verified. Thus, the happy path seems plausible but lacks verifiable execution evidence, so score is capped at 12.
Security and permissions 8/20: The server supports passing database credentials via command-line arguments, but the README examples use placeholders. No hardcoded secrets are present. There are dangerous operations (e.g., drop_table) but the README requires a confirmation flag, which may provide some protection. However, there is no fine-grained permission control or data flow disclosure, and arbitrary SQL execution is likely allowed, so risks are visible but not red-line.
Maintenance 12/20: The repository is active with 379 stars and 23 open issues, and it is not archived. However, detailed information on release frequency, issue response time, and dependency update policy is lacking. The license is MIT, but no security response channel is provided. Thus, maintenance seems active but governance and versioning gaps exist.
Documentation 15/20: The README provides detailed installation, configuration, and tool list, including setup examples for multiple databases and Claude Desktop configuration examples. There are also links to additional documentation (e.g., SQL Server setup guide). However, troubleshooting sections and limitation disclosures are missing, which may leave hidden assumptions.
Setup experience 12/20: Clear installation steps (clone, npm install, npm run build) are provided, along with an option to use the npm package directly. Claude Desktop configuration examples are given for multiple databases. Since nothing was executed, build and startup smoothness cannot be verified, but steps are explicit and reproducibility is high.

Static review · not runListed 2026-08-07

Read the FMRS scoring method →

Fit and risk

What it can accessConnects to a database

Best for

Developers who need to interact with multiple database types
Claude users who want to operate databases using natural language
Scenarios requiring quick data export or insight recording

Not for

Scenarios requiring complex transaction handling or fine-grained permission control
High-concurrency database access in production environments
Non-relational databases (e.g., MongoDB)

Required permissions

Requires database credentials (username, password)
May require network access to connect to remote databases
Requires file system access (for SQLite files)

Risks and side effects

Write operations may cause data loss or corruption; use with caution
Credentials may be recorded in configuration files; manage carefully
Open network ports may pose security risks

Setup

Before you start

Runtime：Node.js 18+

AWS_ACCESS_KEY_ID optionalsecret AWS access key ID used to supply credentials for AWS IAM authentication; create one in the AWS IAM console.

AWS_SECRET_ACCESS_KEY optionalsecret AWS secret access key paired with AWS_ACCESS_KEY_ID; treat as a sensitive credential.

Other optional settings (1)

AWS_PROFILE optional Named AWS CLI profile used by the default credential chain for AWS IAM auth with RDS MySQL; set up via aws configure.

Install the npm package globally: npm install -g @executeautomation/database-server
Add the corresponding MCP server configuration in the Claude Desktop configuration file, using the npx command to start.

claude_desktop_config.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"
      ]
    },
    "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"
      ]
    }
  }
}

Shown for Claude Desktop. Other clients may use a different file or key (VS Code uses "servers") — the configurator below converts it.

.vscode/mcp.json

{
  "servers": {
    "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"
      ]
    }
  }
}

Goes in your project's .vscode/mcp.json (VS Code uses a "servers" key).

Terminal

claude mcp add sqlite -- npx -y @executeautomation/database-server /path/to/your/database.db
claude mcp add sqlserver -- npx -y @executeautomation/database-server --sqlserver --server your-server-name --database your-database-name --user your-username --password your-password
claude mcp add postgresql -- npx -y @executeautomation/database-server --postgresql --host your-host-name --database your-database-name --user your-username --password your-password
claude mcp add mysql -- npx -y @executeautomation/database-server --mysql --host your-host-name --database your-database-name --port 3306 --user your-username --password your-password
claude mcp add mysql-aws -- npx -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

Run it in a terminal; replace any <…> placeholders with your own values first.

Generate and validate client config

Check that it works

Check that tools like read_query and list_tables appear in the client's tool list, then ask the AI to run list_tables; a returned table list confirms the database connection works.

Troubleshooting

Check that Node.js version is >= 18
Ensure database connection parameters (host, port, database name) are correct
For SQL Server, ensure server version >= 2012; for PostgreSQL, ensure version >= 9.5
Check firewall or network settings to ensure access to the database port
Check logs for more detailed error information

Things to try

Once connected, you can ask your AI assistant things like:

List all tables in the database
Run a SELECT query showing the first 10 rows of the employees table
Describe the schema of this table
Export the results of my last SELECT query as CSV

Tools 10

read_query read-only

Execute SELECT queries to read data

write_query writes

Execute INSERT, UPDATE, or DELETE queries

create_table writes

Create new tables in the database

alter_table writes

Modify existing table schema

drop_table destructive

Remove a table from the database

list_tables read-only

Get a list of all tables

describe_table read-only

View schema information for a table

export_query read-only

Export query results as CSV or JSON

Show 2 more tools

append_insight writes

Add a business insight to memo

list_insights read-only

List all business insights

Use cases

Query data from local or remote SQLite databases using natural language

Perform write operations on SQL Server, PostgreSQL, or MySQL databases

Create and modify table schemas

Export data from the database to CSV or JSON formats

Record and retrieve business insights

Supported clients

Claude Desktop

Listed from the project's documentation, not tested by this site.

Overview

MCP Database Server is a Model Context Protocol (MCP) server that enables Claude to interact with various relational databases through a set of tools. It supports SQLite, SQL Server, PostgreSQL, and MySQL. The server provides capabilities for executing queries, managing table schemas, exporting data, and recording business insights.

Similar servers

MCP ClickHouse 79 · B

Connect ClickHouse to your AI assistants

★ 889 · Tools 4 Compare with this →

ChEMBL MCP Server 75 · B

Unofficial MCP server providing advanced access to the ChEMBL chemical database

★ 89 · Tools 27 Compare with this →

MCP Toolbox for Databases 74 · B

Google's official database MCP toolbox — define AI-accessible database tools via config

★ 16.7k Compare with this →

DBHub 74 · B

Bytebase's official, minimalist two-tool database MCP server

★ 3.7k · Tools 2 Compare with this →

Compare with other MCP servers

Source revision d6afa4be08eb Data synced 2026-10-19 Read the FMRS scoring method