Skip to main content
Glama
AYUSH-148

DB-Explorer-MCP

by AYUSH-148
OverviewSchemaRelated ServersScoreDiscussions
Python
Hybrid

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
MCP_HOSTNoHost to bind the HTTP server to when using MCP_TRANSPORT=streamable-http (e.g., 0.0.0.0).
MCP_PORTNoPort to bind the HTTP server to when using MCP_TRANSPORT=streamable-http (e.g., 8000).
DATABASE_URLNoSQLAlchemy database URL. Defaults to a local SQLite database. Examples: sqlite:///C:/data/example.db, postgresql+psycopg2://user:password@localhost:5432/example, mysql+pymysql://user:password@localhost:3306/examplesqlite:///sample.db
MCP_TRANSPORTNoTransport for the MCP server. If set to 'streamable-http', enables HTTP hosting. Defaults to stdio if not set.

Instructions

Guidance the server publishes about itself, which clients place ahead of the tool catalog so the model reads it before choosing anything.

This server publishes no instructions, or was last inspected before Glama recorded them.

Capabilities

Features and capabilities supported by this server

Protocol revision2025-11-25

CapabilityDetails
tools
{
  "listChanged": true
}
logging
{}
prompts
{
  "listChanged": false
}
resources
{
  "subscribe": false,
  "listChanged": false
}
extensions
{
  "io.modelcontextprotocol/ui": {}
}
experimental
{}

Tools

Functions exposed to the LLM to take actions

NameDescription
explore_schemaA

Explore database tables, columns, keys, indexes, and sample rows.

execute_queryB

Execute one validated, read-only SQL SELECT query.

explain_queryA

Return the database execution plan for one safe SELECT query.

validate_schemaC

Check tables for missing primary keys and unindexed foreign keys.

suggest_indexB

Suggest indexes from a query plan or table foreign-key metadata.

migration_contextB

Return schema context for client-side migration generation.

validate_migrationA

Validate migration scripts without executing them.

Prompts

Interactive templates invoked by user choice

NameDescription

No prompts

Resources

Contextual data attached and managed by the client

NameDescription

No resources

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/AYUSH-148/DB-Explorer-MCP'

If you have feedback or need assistance with the MCP directory API, please join our Discord server