Database

The MCP Database Server lets Claude access SQLite, SQL Server, PostgreSQL, and MySQL databases through a single, consistent interface. It supports running locally or via a lightweight CLI path, enabling you to query, modify schemas, and export results from your databases directly in your Claude workflows.

How to use

You use the server by configuring Claude Desktop to point to an MCP server entry and then issuing data queries or schema operations through Claude’s tools. Each database type is represented as its own MCP connection you can choose from when you run queries or manage schemas.

How to install

Prerequisites: Node.js 18+ and npm installed on your system.

Step-by-step setup to get the MCP Database Server running locally or for direct usage.

# Option A: Install the MCP server for direct usage via npm
npm install -g @executeautomation/database-server

# Option B: Clone the repository and build locally
git clone https://github.com/executeautomation/mcp-database-server.git
cd database-server
npm install
npm run build

Additional setup notes

You can run specific database adapters using the provided command lines. The following usage paths are shown to integrate with Claude.

# SQLite example (direct usage)
node dist/src/index.js /path/to/your/database.db

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

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

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

Claude Desktop configuration (direct usage)

If you installed the package globally, configure Claude Desktop to start the MCP connections directly.

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

Claude Desktop configuration (local development)

For local development, configure Claude Desktop to use your locally built MCP server.

{
  "mcpServers": {
    "sqlite_dev": {
      "command": "node",
      "args": [
        "/absolute/path/to/mcp-database-server/dist/src/index.js",
        "/path/to/your/database.db"
      ]
    },
    "sqlserver_dev": {
      "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_dev": {
      "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_dev": {
      "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"
      ]
    }
  }
}

Available database tools and actions

The MCP Database Server exposes a set of practical tools you can run against your databases to read data, modify schemas, or export results. Common actions include reading data with read_query, updating data with write_query, and inspecting table structures with describe_table.

Notes, security and best practices

• Use strong credentials for database connections and prefer encrypted connections where supported.
• Limit the scope of each connection to the minimum required privileges for your tasks.
• When sharing configurations, avoid embedding plain passwords in plain text files. Prefer secret management where possible.

Available tools

read_query

Execute SELECT queries to read data with a specified SQL SELECT statement.

write_query

Execute INSERT, UPDATE, or DELETE queries with a specified SQL statement.

create_table

Create new tables in the connected database using a CREATE TABLE statement.

alter_table

Modify existing table schemas using an ALTER TABLE statement.

drop_table

Remove a table from the database with a safety confirmation flag.

list_tables

Retrieve a list of all tables in the connected database.

describe_table

Show schema information for a specified table.

export_query

Export results of a query as CSV or JSON.

append_insight

Add a business insight to a memo within Claude.

list_insights

List all stored business insights.