Skip to main content
Glama
Citadel-Cloud-Management

mcp-server-database

mcp-server-database

An MCP (Model Context Protocol) server that provides tools for interacting with relational databases. Supports PostgreSQL, MySQL, and SQLite.

Architecture

graph TB
    subgraph Client
        style Client fill:#4A90D9,stroke:#2E6BA6,color:#FFFFFF
        MCP_Client["MCP Client"]
    end

    subgraph Server["mcp-server-database"]
        style Server fill:#2ECC71,stroke:#1A9B52,color:#FFFFFF
        Index["index.ts<br/>MCP Server Entry"]
        subgraph Tools
            style Tools fill:#F39C12,stroke:#C67D0A,color:#FFFFFF
            T1["query"]
            T2["list_tables"]
            T3["describe_table"]
            T4["list_databases"]
            T5["execute_migration"]
            T6["get_schema"]
        end
    end

    subgraph Databases["Database Engines"]
        style Databases fill:#9B59B6,stroke:#7D3C98,color:#FFFFFF
        PG["PostgreSQL"]
        MY["MySQL"]
        SQ["SQLite"]
    end

    MCP_Client -- "stdio transport" --> Index
    Index --> T1 & T2 & T3 & T4 & T5 & T6
    T1 --> PG & MY & SQ
    T2 --> PG & MY & SQ
    T3 --> PG & MY & SQ
    T4 --> PG & MY
    T5 --> PG & MY & SQ
    T6 --> PG & MY & SQ

Related MCP server: SQLx MCP Server

Installation

npm install
npm run build

Configuration

Variable

Description

Required

DB_DRIVER

Database driver: postgres, mysql, or sqlite

Yes

DB_HOST

Database host

Yes (postgres/mysql)

DB_PORT

Database port

No

DB_USER

Database username

Yes (postgres/mysql)

DB_PASSWORD

Database password

Yes (postgres/mysql)

DB_NAME

Database name

Yes

DB_PATH

Path to SQLite file

Yes (sqlite)

Usage

Standalone

DB_DRIVER=postgres DB_HOST=localhost DB_USER=admin DB_PASSWORD=secret DB_NAME=mydb npm start

Development

npm run dev

Docker

docker build -t mcp-server-database .
docker run -e DB_DRIVER=postgres -e DB_HOST=host.docker.internal -e DB_USER=admin -e DB_PASSWORD=secret -e DB_NAME=mydb mcp-server-database

MCP Client Configuration

{
  "mcpServers": {
    "database": {
      "command": "node",
      "args": ["dist/index.js"],
      "env": {
        "DB_DRIVER": "postgres",
        "DB_HOST": "localhost",
        "DB_PORT": "5432",
        "DB_USER": "admin",
        "DB_PASSWORD": "secret",
        "DB_NAME": "mydb"
      }
    }
  }
}

Tool Reference

Tool

Description

Parameters

query

Execute a SQL query

sql, params?

list_tables

List all tables

none

describe_table

Describe a table schema

table_name

list_databases

List databases on the server

none

execute_migration

Execute a migration SQL script

sql

get_schema

Get full database schema DDL

none

License

MIT

Related MCP Connectors

Related MCP Servers

  • A
    license
    Not graded
    quality
    D
    maintenance
    Enables secure interaction with multiple SQL database engines (MySQL, PostgreSQL, SQLite, SQL Server) through a standardized interface. Supports schema inspection, safe query execution, and controlled write operations with built-in security restrictions.
    5
    MIT
  • A
    license
    Not graded
    quality
    C
    maintenance
    Provides comprehensive database management tools for PostgreSQL, MySQL, and SQLite databases. Enables querying table structures, executing read-only and write queries, exporting DDL statements, and managing database metadata through natural language.
    2 npm
    MIT
  • A
    license
    Not graded
    quality
    D
    maintenance
    Enables interaction with SQLite, MySQL, PostgreSQL, and SQL Server databases through tools for connection management, parameterized query execution, and schema inspection.
    4 npm
    1
    MIT
  • A
    license
    A
    quality
    D
    maintenance
    Database management — connect, query, describe schemas, run migrations, and monitor active queries across PostgreSQL, MySQL, and SQLite.
    15
    MIT