code-alchemist01/database-manager-mcp-Server
If you are the rightful owner of database-manager-mcp-Server 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.
MCP Database Manager is a comprehensive server designed for database management and analysis, supporting multiple database types and facilitating AI assistants in interacting with databases.
Tools
Functions exposed to the LLM to take actions
connect_database
Connect to a database
list_connections
List active connections
disconnect_database
Close a database connection
test_connection
Test a database connection
analyze_query
Analyze an SQL query
explain_query
Show execution plan
optimize_query
Provide query optimization suggestions
detect_slow_queries
Identify slow queries
suggest_indexes
Suggest indexes for optimization
get_schema
Retrieve schema information
visualize_schema
Create an ER diagram (Mermaid)
analyze_foreign_keys
Analyze foreign keys
generate_migration
Generate migration script
document_schema
Document the schema
get_table_stats
Get table statistics
analyze_data_quality
Analyze data quality
find_duplicates
Find duplicate records
sample_data
Sample data from tables
generate_report
Generate a custom report
create_backup
Create a database backup
list_backups
List available backups
restore_backup
Restore from a backup
verify_backup
Verify the integrity of a backup
analyze_permissions
Analyze database permissions
detect_vulnerabilities
Detect security vulnerabilities
find_sensitive_data
Identify sensitive data
audit_logs
Analyze audit logs
Prompts
Interactive templates invoked by user choice
No prompts
Resources
Contextual data attached and managed by the client