Skip to content
Agentmart
Submit a tool

DB Explorer

Read-only SQL for PostgreSQL, MySQL and SQLite: schema, safe SELECTs, EXPLAIN, index advice

Connector by AYUSH-148 · GitHub account verified by the MCP Registry

IndexedMITLocal (stdio)★ 8
Write a review

Install

Works with Claude Code, Codex, VS Code, Cursor, Windsurf, Claude Desktop. Read the repository before you give any tool access to your data.

npx agentmarket install connector/ayush-148-db-explorer-mcp-server

Asks which of your tools to add it to (Claude Code, Codex, Cursor, VS Code, Windsurf, Gemini CLI, Claude Desktop) and shows the change first. See https://agentmart.dev/cli.

Get the weekly diff

The weekly diff: one email a week with new agent tools, notable updates and grade changes, plus security alerts for tools you follow. Double opt-in, one-click unsubscribe.

We use your email only for this newsletter. Privacy

About

Read-only SQL for PostgreSQL, MySQL and SQLite: schema, safe SELECTs, EXPLAIN, index advice

No reviews yet. Installed it? Reviews come from verified installers only. How reviews work

Permissions

What this server can do and what it asks for, from its tool list, install config and code. Checked Oct 25, 2026.

Tools
7 read · 0 write · 0 deleteRead-only
Secrets
1 (API keys, tokens or passwords)
Install scripts
None found
Runs as
Python package

Tools by what they do 7

Read from the source code; the running server may list different tools.

Read 7 · Look things up without changing anything.

  • execute_query
  • explain_query
  • explore_schema
  • migration_context
  • suggest_index
  • validate_migration
  • validate_schema

Secrets and settings it asks for

Secrets: values you paste in that let it act as you.

  • DATABASE_URL

Network hosts it talks to 2

  • db-explorer-mcp.fastmcp.app · found in code
  • github.com · found in code

Tools (7)

Read from the source code; the running server may differ. Descriptions are the server’s own words; hidden characters are shown as [U+…].

  • execute_query

    Run one read-only SELECT and return its rows. The result is capped by row_limit and by size. truncated=true means more rows exist: filter with WHERE or aggregate rather than raising row_limit. Repeated column names come back labelled name:1, name:2; alias them in the query.

  • explain_query

    Return the database's execution plan for one SELECT, without running it.

  • explore_schema

    List the database's tables and views, or describe one in detail. Every result names the SQL dialect to write queries in. Table and column comments stored in the database come with table_name or detail=true, not with the default listing. CHECK constraints, triggers and view definitions are never included, so their absence here says nothing about the database. A listing comes in pages. A page can hold fewer tables than limit when it reaches the size cap, so continue with offset=next_offset, never offset+limit.

  • migration_context

    Return dialect and one page of table detail for client-side migration drafting. A page can hold fewer tables than limit when it reaches the size cap, so continue with offset=next_offset, never offset+limit.

  • suggest_index

    Suggest indexes for one table or one query. With table_name, returns a CREATE INDEX for each foreign key no index covers. With query, reports the full table scans in its plan, without generated SQL. Nothing is created: the caller decides whether to run a suggestion.

  • validate_migration

    Check migration scripts without executing them. Reports each statement's type and rejects SELECT, comments and unbalanced parentheses. It does not check syntax: the database reports other errors when the script is run.

  • validate_schema

    Check tables for missing primary keys, unindexed foreign keys, very wide tables and tables with no indexes. A page of tables leaves views out.

Signals

Stars
8
Forks
2
Open issues
0
Weekly downloads
138
Last commit
Oct 20, 2026 (8 days ago)
Last release
Oct 20, 2026 (8 days ago)
Last package publish
Oct 20, 2026 (8 days ago)

From GitHub (fetched Oct 24, 2026) and the package registry.

Details

Registry name
io.github.AYUSH-148/db-explorer-mcp-server
Version
0.1.0
Auth
API key
License
MIT
First seen
Oct 24, 2026
Last checked
Oct 25, 2026
Cite this page

DB Explorer MCP server. Agent Mart. https://agentmart.dev/connectors/ayush-148-db-explorer-mcp-server (last updated 2026-10-25)