Database Schema MCP Server

🚀 Database Schema Server MCP Server

A powerful MCP server that provides tools to read and expose the database schemas of various database types (PostgreSQL, MySQL, SQLite, etc.).

🚀 Quick Start

This server is designed to connect to different types of databases and retrieve detailed schema information. It supports multiple database types such as PostgreSQL, MySQL, and SQLite.

✨ Features

• Connect to different types of databases.
• List all tables in the database.
• Get detailed schema information for a specific table.
• Obtain the complete database schema, including tables, views, and indexes.
• Support multiple database types (PostgreSQL, MySQL, SQLite).

📦 Installation

Prerequisites

1. Python 3.x
2. Virtual environment (recommended)

Basic Installation

1. Create and activate a virtual environment:

# Create a virtual environment
python -m venv venv

# Activate the virtual environment
# On Unix/macOS:
source venv/bin/activate
# On Windows:
venv\Scripts\activate

2. Install dependencies:

pip install -r requirements.txt

Windows MCP Installation

1. Install Node.js:

   • Download and install from the official Node.js website.
   • Verify the installation in PowerShell by running node --version.

2. Update the system path:

$env:Path = [System.Environment]::GetEnvironmentVariable("Path","Machine") + ";" + [System.Environment]::GetEnvironmentVariable("Path","User")

3. If Node.js is not recognized, manually add it to the Path:

   • Press Windows + R.
   • Enter sysdm.cpl and press Enter.
   • Go to the "Advanced" tab.
   • Click "Environment Variables".
   • Find and select "Path" under "System variables".
   • Click "Edit".
   • Add C:\Program Files\nodejs\ if it doesn't exist.
   • Click "OK" on all windows.
   • Restart the computer.

4. Install MCP:

   • Download the mcp-install.ps1 script.
   • Unlock the file (right-click → Properties → Unlock).
   • Run the following in PowerShell as an administrator:

     Set-ExecutionPolicy unrestricted
     

   • Navigate to the script location and run:

     .\mcp-install.ps1 @modelcontextprotocol/server-postgres
     

   • Completely exit Claude Desktop (check the system tray).
   • Configure the server in C:\Users\YOUR_USERNAME\AppData\Roaming\Claude\claude_desktop_config.json.
   • Copy the MCP server configuration to mcp.json in Cursor.
   • Restart Cursor.

MCP Configuration Example

Create a .cursor/mcp.json file in the project root directory with the following structure:

{
    "mcpServers": {
        "local-db": {
            "args": [
                "C:\\Users\\YOUR_USERNAME\\AppData\\Roaming\\npm\\node_modules\\@modelcontextprotocol\\server-postgres\\dist\\index.js",
                "database-url"
            ],
            "command": "node"
        },
        "staging-db": {
            "args": [
                "C:\\Users\\YOUR_USERNAME\\AppData\\Roaming\\npm\\node_modules\\@modelcontextprotocol\\server-postgres\\dist\\index.js",
                "database-url"
            ],
            "command": "node"
        },
        "production-db": {
            "args": [
                "C:\\Users\\YOUR_USERNAME\\AppData\\Roaming\\npm\\node_modules\\@modelcontextprotocol\\server-postgres\\dist\\index.js",
                "database"
            ],
            "command": "node"
        }
    }
}