Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||
Capabilities
Features and capabilities supported by this server
| Capability | Details |
|---|---|
| tools | {
"listChanged": true
} |
| prompts | {} |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| describe_table | Shows detailed schema information for a specific table including columns, types, keys, and relationships |
| execute_procedure | Executes a stored procedure by name with optional parameters. Parameters are passed as a JSON object string. Only available on non-read-only sources. |
| get_daily_sales | Retrieves daily sales summary for a specific date |
| get_pending_orders | Gets all orders with pending status |
| get_top_customers | Lists top N customers by order count |
| list_procedures | Lists all stored procedures in a database source with their parameters. Use 'execute_procedure' to run one. |
| list_tables | Lists all available tables in a database source with their column counts |
| list_views | Lists all database views in a source with their columns. Views are virtual tables based on stored queries. |
| query_database | Executes a SQL query on a specified database source. Use this to retrieve data. |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
| database_schema | Shows the complete database schema with tables, columns, types, and relationships |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |