Database MCP Server

by MCP-Mirror

257 downloads Not rated yet
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.

Explore

- 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

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

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

def list_tools():
response = requests.post(f"{BASE_URL}/list_tools")
return response.json()

def call_tool(tool_name, arguments):
payload = {
"name": tool_name,
"arguments": arguments
}
response = requests.post(f"{BASE_URL}/call_tool", json=payload)
return response.json()

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

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.