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
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.
About
Reviews
Write a reviewNo 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_queryexplain_queryexplore_schemamigration_contextsuggest_indexvalidate_migrationvalidate_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 codegithub.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_queryRun 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_queryReturn the database's execution plan for one SELECT, without running it.
explore_schemaList 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_contextReturn 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_indexSuggest 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_migrationCheck 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_schemaCheck 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
- Packages
- pypi db-explorer-mcp-server
- License
- MIT
- Repository
- github.com/AYUSH-148/DB-Explorer-MCP
- 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)