database-admin

Validated

Database admin MCP: schema inspection, query optimization for PostgreSQL and MySQL

Registry

Data & Analytics Databases

Tools

Validated

Jan 9, 2026

View Source

Claim this server

Validation Details

Duration: 5.2s

Server: database-admin-mcp v1.0.0

Quick Install

npx -y database-admin-mcp

list_tables

List all tables in the database with their size and index count.

describe_table

Get detailed schema information about a table including columns, types, indexes, and foreign keys.

sample_data

Retrieve sample rows from a table to understand its data structure and content.

execute_query

Execute a SQL query and return results. By default, only SELECT queries are allowed (read-only mode). Set DB_READ_ONLY=false to enable write operations.

analyze_indexes

Analyze table indexes for usage statistics, unused indexes, and optimization suggestions.

explain_query

Get query execution plan with cost estimates and optimization suggestions.

generate_migration

Generate SQL migration scripts for schema changes with up/down migrations.

get_relationships

Get all foreign key relationships in the database as a graph showing table connections.

get_connection_info

Get current database connection configuration and mode settings.

Reviews

No reviews yet