arnav1997/mcpsql-lab
If you are the rightful owner of mcpsql-lab 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.
This document provides a comprehensive overview of a Model Context Protocol (MCP) server designed for SQL analysis, featuring built-in tools and extensibility options.
Tools
Functions exposed to the LLM to take actions
echo
Echoes text back for sanity testing.
ping
Performs a health check, returning 'pong'.
list_tables
Lists user tables with schema, table, and size information.
describe_table
Inspects table schema, including columns, primary keys, foreign keys, and indexes.
run_sql
Executes read-only SQL queries and returns results.
generate_sql
Generates Postgres SQL from natural language queries.
Prompts
Interactive templates invoked by user choice
No prompts
Resources
Contextual data attached and managed by the client