Skip to main content
Glama
DB MCP Server

DB MCP Server

DB MCP Server

A Model Context Protocol (MCP) server for database operations. Execute queries, introspect schemas, and manage data for PostgreSQL and MySQL databases. Works with local databases, SSH tunnels, AWS RDS, RDS Proxy, and any compatible database.

Features

  • db_list_instances - List RDS database instances (requires AWS credentials)

  • db_test_connection - Test database connectivity and get version info

  • db_execute_query - Execute read-only SQL queries (SELECT, SHOW, DESCRIBE, EXPLAIN)

  • db_execute_write - Execute write queries (INSERT/UPDATE only, DELETE blocked)

  • db_get_schema - Get full database schema with tables, views, and columns

  • db_get_tables - List tables and views with filtering options

  • db_get_columns - Get column details for a specific table

  • db_sample_data - Get sample rows from a table

Related MCP server: MCP MySQL Server

Installation

No installation required. Add directly to your config:

Claude Desktop (~/Library/Application Support/Claude/claude_desktop_config.json on macOS):

{
  "mcpServers": {
    "db": {
      "command": "npx",
      "args": ["-y", "github:nikhilchintawar/db-mcp"],
      "env": {
        "DB_HOST": "localhost",
        "DB_PORT": "5432",
        "DB_NAME": "mydb",
        "DB_USER": "postgres",
        "DB_PASSWORD": "password",
        "DB_ENGINE": "postgresql"
      }
    }
  }
}

Claude Code (~/.claude/settings.json):

{
  "mcpServers": {
    "db": {
      "command": "npx",
      "args": ["-y", "github:nikhilchintawar/db-mcp"],
      "env": {
        "DB_HOST": "localhost",
        "DB_PORT": "5432",
        "DB_NAME": "mydb",
        "DB_USER": "postgres",
        "DB_PASSWORD": "password",
        "DB_ENGINE": "postgresql"
      }
    }
  }
}

Manual Installation

# Clone the repository
git clone https://github.com/nikhilchintawar/db-mcp.git
cd db-mcp

# Install dependencies
npm install

# Build
npm run build

Then add to your config:

{
  "mcpServers": {
    "db": {
      "command": "node",
      "args": ["/absolute/path/to/db-mcp/build/index.js"],
      "env": {
        "DB_HOST": "localhost",
        "DB_PORT": "5432",
        "DB_NAME": "mydb",
        "DB_USER": "postgres",
        "DB_PASSWORD": "password",
        "DB_ENGINE": "postgresql"
      }
    }
  }
}

Configuration Examples

Local Database

{
  "mcpServers": {
    "db": {
      "command": "npx",
      "args": ["-y", "github:nikhilchintawar/db-mcp"],
      "env": {
        "DB_HOST": "localhost",
        "DB_PORT": "5432",
        "DB_NAME": "mydb",
        "DB_USER": "postgres",
        "DB_PASSWORD": "password",
        "DB_ENGINE": "postgresql",
        "DB_SSL": "false"
      }
    }
  }
}

SSH Tunnel

First, establish your SSH tunnel:

ssh -L 5432:rds-endpoint.amazonaws.com:5432 bastion-host

Then configure:

{
  "mcpServers": {
    "db": {
      "command": "npx",
      "args": ["-y", "github:nikhilchintawar/db-mcp"],
      "env": {
        "DB_HOST": "localhost",
        "DB_PORT": "5432",
        "DB_NAME": "mydb",
        "DB_USER": "admin",
        "DB_PASSWORD": "password",
        "DB_ENGINE": "postgresql"
      }
    }
  }
}

AWS RDS / RDS Proxy

{
  "mcpServers": {
    "db": {
      "command": "npx",
      "args": ["-y", "github:nikhilchintawar/db-mcp"],
      "env": {
        "DB_HOST": "my-proxy.proxy-xxxx.us-east-1.rds.amazonaws.com",
        "DB_PORT": "5432",
        "DB_NAME": "mydb",
        "DB_USER": "admin",
        "DB_PASSWORD": "password",
        "DB_ENGINE": "postgresql"
      }
    }
  }
}

AWS RDS with Temporary Credentials (Read Replica)

{
  "mcpServers": {
    "db": {
      "command": "npx",
      "args": ["-y", "github:nikhilchintawar/db-mcp"],
      "env": {
        "AWS_REGION": "eu-west-1",
        "AWS_ACCESS_KEY_ID": "your-access-key",
        "AWS_SECRET_ACCESS_KEY": "your-secret-key",
        "AWS_SESSION_TOKEN": "your-session-token",
        "DB_HOST": "my-proxy-readonly.proxy-xxxx.eu-west-1.rds.amazonaws.com",
        "DB_PORT": "5432",
        "DB_NAME": "mydb",
        "DB_USER": "admin",
        "DB_PASSWORD": "password",
        "DB_ENGINE": "postgresql",
        "DB_IS_READ_REPLICA": "true",
        "DB_WRITE_MODE": "disabled"
      }
    }
  }
}

AWS Secrets Manager

{
  "mcpServers": {
    "db": {
      "command": "npx",
      "args": ["-y", "github:nikhilchintawar/db-mcp"],
      "env": {
        "AWS_REGION": "us-east-1",
        "AWS_PROFILE": "your-profile",
        "DB_SECRET_ARN": "arn:aws:secretsmanager:us-east-1:123456789012:secret:mydb-AbCdEf"
      }
    }
  }
}

Configuration

Config File Locations

  • Claude Desktop (macOS): ~/Library/Application Support/Claude/claude_desktop_config.json

  • Claude Desktop (Windows): %APPDATA%\Claude\claude_desktop_config.json

  • Claude Code: ~/.claude/settings.json

Environment Variables

Variable

Required

Description

DB_HOST

Yes*

Database hostname

DB_PORT

No

Database port (default: 5432 for PostgreSQL, 3306 for MySQL)

DB_NAME

Yes*

Database name

DB_USER

Yes*

Database username

DB_PASSWORD

Yes*

Database password

DB_ENGINE

Yes*

postgresql or mysql

DB_SSL

No

Enable SSL (default: true)

DB_SECRET_ARN

No

AWS Secrets Manager ARN (alternative to direct credentials)

DB_WRITE_MODE

No

disabled (default), enabled, or auto

DB_IS_READ_REPLICA

No

Set to true to block writes

DB_DEFAULT_LIMIT

No

Default query row limit (default: 1000)

DB_DEFAULT_TIMEOUT

No

Default query timeout in ms (default: 30000)

*Required unless using DB_SECRET_ARN

AWS Configuration (Optional)

AWS credentials are only needed if using:

  • DB_SECRET_ARN (Secrets Manager)

  • db_list_instances tool (RDS API)

Variable

Description

AWS_REGION

AWS region (required for AWS features)

AWS_PROFILE

AWS credentials profile

AWS_ACCESS_KEY_ID

AWS access key

AWS_SECRET_ACCESS_KEY

AWS secret key

AWS_SESSION_TOKEN

Session token (for temporary credentials)

Usage Examples

Once configured, you can use natural language to interact with your database:

  • "Show me the database schema"

  • "List all tables"

  • "Get sample data from the users table"

  • "Run a query to find all orders from last week"

  • "Insert a new record into the settings table"

  • "Show me the columns in the products table"

Available Tools

db_list_instances

List RDS database instances (requires AWS credentials).

Parameter

Required

Description

identifier

No

Filter by instance identifier

engine

No

Filter by engine (postgres, mysql)

db_test_connection

Test database connection and return status, latency, and version.

Parameter

Required

Description

(none)

-

Uses configured connection

db_execute_query

Execute read-only SQL queries.

Parameter

Required

Description

sql

Yes

SELECT, SHOW, DESCRIBE, or EXPLAIN query

limit

No

Max rows (default: 1000, max: 10000)

timeout

No

Query timeout in ms (default: 30000)

db_execute_write

Execute write operations (INSERT/UPDATE only).

Parameter

Required

Description

sql

Yes

INSERT or UPDATE query

timeout

No

Query timeout in ms (default: 30000)

Note: DELETE, DROP, TRUNCATE, and ALTER are blocked. Fails gracefully on read replicas.

db_get_schema

Get full database schema including tables, views, and columns.

Parameter

Required

Description

schemaName

No

Filter by schema (e.g., "public")

db_get_tables

List tables and views.

Parameter

Required

Description

schemaName

No

Filter by schema

type

No

table, view, or all (default)

db_get_columns

Get column details for a specific table.

Parameter

Required

Description

table

Yes

Table name

schemaName

No

Schema name

db_sample_data

Get sample rows from a table.

Parameter

Required

Description

table

Yes

Table name

schemaName

No

Schema name

limit

No

Number of rows (default: 10, max: 100)

Write Protection

The server includes multiple safety mechanisms:

Mode

Behavior

disabled (default)

Blocks all write operations

enabled

Allows INSERT/UPDATE on any instance

auto

Allows INSERT/UPDATE except on read replicas

Always blocked: DELETE, DROP, TRUNCATE, ALTER, CREATE, GRANT, REVOKE

Read replica detection works via:

  1. DB_IS_READ_REPLICA=true environment variable

  2. Automatic detection via RDS API (requires DB_RDS_INSTANCE_IDENTIFIER and AWS credentials)

Development

# Watch mode for development
npm run dev

# Build for production
npm run build

# Test with MCP Inspector
npx @modelcontextprotocol/inspector node build/index.js

License

MIT

Available Tools

8 tools
db_execute_queryA

Execute a read-only SQL query (SELECT, SHOW, DESCRIBE, EXPLAIN). Returns columns, rows, and execution metadata.

Inputs: sql (required), limit, timeout.

db_execute_writeB

Execute a write SQL query (INSERT or UPDATE only). DELETE is not allowed. Fails gracefully on read replicas.

Inputs: sql (required), timeout.

db_get_columnsA

Get column details for a specific table including data types, nullable flags, and key constraints.

Inputs: table (required), schemaName.

db_get_schemaA

Get the full database schema including all tables, views, and their columns with data types and constraints.

Inputs: schemaName.

db_get_tablesB

List all tables and views in the database. Can filter by schema name and object type.

Inputs: type, schemaName.

db_list_instancesA

List RDS database instances in the AWS account. Requires AWS credentials. Use this to discover available databases, their endpoints, and status.

Inputs: engine, identifier.

db_sample_dataA

Get sample rows from a table to understand its data structure and content.

Inputs: table (required), limit, schemaName.

db_test_connectionA

Test the database connection and return connection status, latency, and database version.

Inputs: no named parameters.

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

Loading tool schema changelog…

    TDQS

    A3.7/5.0

    Scored across 8 tools

    Disambiguation4/5

    Each tool targets a distinct operation: instance discovery, connectivity testing, read queries, write queries, and schema introspection. The schema-related tools (get_schema, get_tables, get_columns) have some overlap but their descriptions make the scope clear enough to avoid serious confusion.

    Naming Consistency4/5

    Tool names consistently use a db_ prefix with snake_case and mostly follow a verb_noun pattern. The main deviation is db_sample_data, which lacks an explicit verb, and list vs get are used inconsistently (list_instances vs get_tables).

    Tool Count5/5

    Eight tools is well-scoped for a database MCP server. Each tool serves a meaningful purpose without unnecessary redundancy or bloat.

    Completeness4/5

    The surface covers instance discovery, connection testing, schema inspection, data sampling, and both read and safe write operations. Minor gaps include lack of DELETE support, DDL/transactions, and explicit database selection tools, but these appear intentional or edge-case.

    Maintenance

    ActivityInactive
    ResponsivenessNo recent community issues

    Related MCP Connectors

    Related MCP Servers

    • A
      license
      Not graded
      quality
      D
      maintenance
      Enables AI assistants to interact with PostgreSQL and Supabase databases through natural language. Supports secure database operations including queries, migrations, and schema management with user-provided credentials.
      41 npm
      1
      MIT
    • A
      license
      A
      quality
      D
      maintenance
      Enables interaction with MySQL databases (including AWS RDS and cloud instances) through natural language. Supports database connections, query execution, schema inspection, and comprehensive database management operations.
      8
      26 npm
      7
      MIT
    • A
      license
      A
      quality
      D
      maintenance
      Enables querying and managing PostgreSQL and MySQL databases through natural language, supporting connection management, query execution, schema inspection, and parameterized queries with connection pooling.
      5
      15 npm
      4
      MIT
    • A
      license
      A
      quality
      C
      maintenance
      Enables interaction with MySQL databases (including AWS RDS and cloud instances) through natural language, supporting query execution, schema inspection, index management, and comprehensive database operations with secure SSL connections.
      8
      2 npm
      MIT