Dbecho

by ginkida

306 downloads
Not rated
GitHub

About

MCP server for multi-database PostgreSQL analytics. Ask your databases questions in natural language - get schema exploration, profiling, trends, anomaly detection, and cross-database comparisons. Read-only, safe, local.

Details

Author
ginkida
Downloads
306
Categories
Database

- 11 tools: schema, query, analyze, compare, trend, anomalies, sample, erd, health, summary, list_databases
- Read-only safety enforced at the database level
- Supports multiple PostgreSQL databases in one config
- Compare databases with a single tool call
- Pure Python, zero infrastructure required
- Requires Python 3.10+

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 Dbecho
    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 with pip install, configure your PostgreSQL connection(s) in a TOML file, and Dbecho exposes 11 tools, 3 MCP resources, and 3 MCP prompts to your MCP-compatible AI agent.

Claude Desktop / Cursor

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

{
    "mcpServers": {
        "dbecho": {
            "dbecho": {
                "command": "dbecho",
                "args": [
                    "--config",
                    "/path/to/dbecho.toml"
                ]
            }
        }
    }
}

McpServers

{
    "dbecho": {
        "command": "dbecho",
        "args": [
            "--config",
            "/path/to/dbecho.toml"
        ]
    }
}

dbecho gives AI agents (Claude Code, Cursor, Windsurf) direct read-only access to your PostgreSQL databases.

11 tools: schema, query, analyze, compare, trend, anomalies, sample, erd, health, summary, list_databases. Plus 3 MCP resources and 3 MCP prompts.

Safety: read-only connections (default_transaction_read_only=on), query whitelist (SELECT/WITH/EXPLAIN/SHOW only), SQL injection prevention via
psycopg.sql.Identifier, query timeouts, row limits. Safe to point at production.

Multi-database: connect multiple PostgreSQL databases in one TOML config, compare across them with a single tool call.

Zero infrastructure: pure Python package, stdio transport, no containers or web UI needed.

Requires Python 3.10+. Install: pip install dbecho

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.