FusionGuy/mcp-db-analyzer
If you are the rightful owner of mcp-db-analyzer and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to dayong@mcphub.com.
The DB Analyzer MCP Server is a Model Context Protocol server designed to provide comprehensive SQL Server database analysis and query capabilities for AI assistants like Claude.
Tools
Functions exposed to the LLM to take actions
ping_db
Test database connectivity and retrieve server information
execute_query
Execute SELECT queries with optional row limits
execute_non_query
Execute DDL/DML statements (CREATE, UPDATE, DELETE, etc.)
execute_stored_procedure
Call stored procedures with typed parameters
list_databases
List all databases with optional name filtering
list_schemas
List schemas in a specific database
list_tables
List tables with optional schema/name filtering
get_table_columns
Get detailed column information including types, constraints, and primary keys
get_indexes
Retrieve index information for specific tables
analyze_schema_health
Comprehensive database health check
Prompts
Interactive templates invoked by user choice
No prompts
Resources
Contextual data attached and managed by the client