Database MCP Server

by MCP-Mirror

257 downloads
Not rated
GitHub

About

A Model Context Protocol (MCP) server that provides tools for connecting to and interacting with various database systems, including SQLite, PostgreSQL, MySQL/MariaDB, and SQL Server, through a unified interface.

Details

Author
MCP-Mirror
Downloads
257
Categories
Database

- Multi-database support: SQLite, PostgreSQL, MySQL/MariaDB, SQL Server
- Unified interface for common database operations
- Schema management: create, alter, drop tables and indexes
- Query execution: raw SQL or structured query tools
- Transaction support: begin, commit, rollback
- Standalone web server mode for use with any LLM

Setting up with Highlight

This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:

  1. Download and install Highlight from highlightai.com/download
  2. Navigate to the plugins tab and select "Add Custom Plugin"
  3. Configure the plugin with the settings below
    Plugin Name Database MCP Server
    Command (node, npx, python, etc.)

    Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.

  4. Enable "Start Automatically" if you want the plugin to start when Highlight launches

From the repository

Install from source with pip install -e ., configure via environment variables or a JSON config file, then run python -m db_mcp_server (MCP mode) or python -m db_mcp_server.web_server (standalone web server). Use the provided MCP tools for connection management, query execution, schema management, and transaction control.

Claude Desktop / Cursor

Paste into your MCP client config file to install this server.

{
    "mcpServers": {
        "database mcp server": {
            "georgi-terziyski_database_mcp_server": {
                "command": "python",
                "args": [
                    "-m",
                    "db_mcp_server"
                ]
            }
        }
    }
}

McpServers

{
    "georgi-terziyski_database_mcp_server": {
        "command": "python",
        "args": [
            "-m",
            "db_mcp_server"
        ]
    }
}

Database MCP Server

A Model Context Protocol (MCP) server that provides tools for connecting to and interacting with various database systems.

Features

- Multi-Database Support: Connect to SQLite, PostgreSQL, MySQL/MariaDB, and SQL Server databases
- Unified Interface: Common tools for database operations across all supported database types
- Database-Specific Extensions: Where needed, specific tools for database-specific features
- Schema Management: Create, alter, and drop tables and indexes
- Query Execution: Execute raw SQL queries or use structured query tools
- Transaction Support: Begin, commit, and rollback transactions

Installation

Prerequisites

- Python 3.8 or higher
- Required Python packages (installed automatically with pip):
- SQLAlchemy
- Various database drivers, depending on which databases you want to use:
- SQLite (included with Python)
- PostgreSQL: psycopg2-binary
- MySQL/MariaDB: mysql-connector-python
- SQL Server: pyodbc

Installing from Source

```bash

No reviews yet — be the first

Sign in to leave a review

Use Google, GitHub, or an email account so ratings stay tied to real people.

Email sign in

No reviews posted yet.