pickfit

BrowseMCP servers

DB Explorer MCP

Read-only MCP server letting AI assistants explore schemas and run safe SELECTs on Postgres, MySQL, SQLite.

Tested on Linux

Use it

Linux x86_64

You need first

  • Runtimes: Python 3.11+
  1. git clone https://github.com/AYUSH-148/DB-Explorer-MCP.git repo

    git clone https://github.com/AYUSH-148/DB-Explorer-MCP.git repo
  2. uv sync (installs dependencies)

    cd repo && uv sync

Check that it works

cd repo && uv run pytest -q

The output should contain “336 passed”.

First thing to try

cd repo && uv run pytest -q

Add it to your agent

claude mcp add db-explorer-mcp -e DATABASE_URL='<DATABASE_URL>' -e MCP_AUTH_TOKEN='<MCP_AUTH_TOKEN>' -- uv run server.py
JSON for Claude Desktop, Cursor and other clients
{
  "mcpServers": {
    "db-explorer-mcp": {
      "command": "uv",
      "args": [
        "run",
        "server.py"
      ],
      "env": {
        "DATABASE_URL": "<DATABASE_URL>",
        "MCP_AUTH_TOKEN": "<MCP_AUTH_TOKEN>"
      }
    }
  }
}

You fill in

  • DATABASE_URL: database connection string (required)
  • MCP_AUTH_TOKEN: bearer token for HTTP (required)

Ask the user for DATABASE_URL, MCP_AUTH_TOKEN; pickfit never had a value, so these are placeholders.

Start the server with uv run server.py from the project folder and connect it to your MCP client.

What it does

  • Explore database schemas
    How to use it
    1. Start the server with uv run server.py and connect your MCP client.
    2. Call the explore_schema tool with no arguments to list tables and columns.
    Tested
  • Run safe SELECT queries
    How to use it
    1. Start the server with uv run server.py and connect your MCP client.
    2. Call the execute_query tool with {"sql": "<your SELECT query>"}.
    Tested
  • Read EXPLAIN query plans
    How to use it
    1. Start the server with uv run server.py and connect your MCP client.
    2. Call the explain_query tool with {"sql": "<your SELECT query>"} to see its execution plan.
    Tested
  • Get index suggestions
    Not shown working

How far pickfit got

Linux x86_64

  1. Installs
  2. Connects
  3. 3 of 4 features work
  4. Works offline

Good for

  • list tables and find missing primary keys
  • query top rows from orders table
  • explain slow query execution plan
  • suggest indexes for unindexed foreign keys
  • draft and validate database migration scripts

How pickfit tested it

Each run starts from a clean machine and follows the steps above. How pickfit verifies

Linux x86_64

An MCP client called one of its tools

  • Replayed from scratch
  • Works offline
  • Checked on 1 Nov 2026
  • Version 3.4.7

An MCP client handshake over stdio listed 7 tools, and a call to explore_schema returned a result.

How to read a tool card

Stitching
pickfit installed this tool itself. Everything under the stitches comes from that run. A tool pickfit has not run never gets stitches.
Verified on your OS
The install steps ran on the system you chose. “Ran on Linux only” means it has not been run on yours yet.
macOS, Linux and WindowsWhere it ran
Green OS marks: pickfit ran the install steps there. Grey ones: the README says it runs there, and pickfit has not tried.
How far the run got
Installs and starts, its main function works, its service answers, it produces model output. A window means a desktop app opened; a plug, an MCP client used it. The mark sits beside the run’s result, under “Why it fits and how we know” and in “How pickfit tested it”.
Visual check
pickfit looked at screenshots of the app. Green: it looks right. Amber with a number: things that look wrong; open it to see them. Grey and dashed: not checked yet.
Known vulnerabilities
Known high or critical vulnerabilities (OSV.dev) in what it installs. Green: none known. Red with a number: how many; open it for the list, and read it before you install. Grey and dashed: not checked, which does not mean safe.
About the run
The day it ran, and the version that ran.
Source of a reason
Every reason a pick fits rests on one profile field. Open the reason to see the field and the value it relies on.
Hidden gem
High quality, little known.
Quality and popularity
Two scores out of 100. Quality: how well it installed and worked when pickfit tried it, and how good its install docs and upkeep are. Popularity: from stars, downloads and Hacker News.
Features checked
Of the main features the README advertises, how many the run actually exercised (green), and how many failed (red). Grey ones were not checked, and the card says why.
Not verified
A well-known tool Fitz mentions from general knowledge. No run record, no steps, no score.