hendrickcastro/MCPQL
If you are the rightful owner of MCPQL and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
MCPQL is a Model Context Protocol server designed for SQL Server database operations, offering tools for analysis, discovery, and manipulation.
Tools
Functions exposed to the LLM to take actions
mcp_table_analysis
Complete table structure analysis including columns, keys, indexes, and constraints.
mcp_sp_structure
Analyze stored procedure structure including parameters, dependencies, and source code.
mcp_preview_data
Preview table data with optional filtering and row limits.
mcp_get_column_stats
Get comprehensive statistics for a specific column.
mcp_execute_procedure
Execute stored procedures with parameters and return results.
mcp_execute_query
Execute custom SQL queries with full error handling.
mcp_quick_data_analysis
Quick statistical analysis including row count, column distributions, and top values.
mcp_search_comprehensive
Search across database objects by name and definition with configurable criteria.
mcp_get_dependencies
Get dependencies for database objects (tables, views, stored procedures, etc.).
mcp_get_sample_values
Get sample values from a specific column in a table.
Prompts
Interactive templates invoked by user choice
No prompts
Resources
Contextual data attached and managed by the client