Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||
Schema
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
| sql_analysis_prompt | Generate a prompt for analyzing SQL query results |
| data_exploration_prompt | Generate a prompt for exploring a data table |
| sql_optimization_prompt | Generate a prompt for SQL query optimization |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
| get_databases_resource | Resource to get list of databases |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| execute_sql | Execute a SQL query on Snowflake and return results |
| list_databases | List all databases available to the user |
| list_schemas | List all schemas in a database |
| list_tables | List all tables in a database/schema |
| describe_table | Get detailed information about a table's columns |
| get_table_sample | Get a sample of data from a table |
| list_warehouses | List all warehouses available to the user |
| get_warehouse_status | Get current warehouse, database, and schema status |
| natural_language_to_sql | Convert natural language question to SQL query using AI |
| analyze_query_results | Execute a query and analyze its results using AI |
| suggest_query_optimizations | Get AI-powered suggestions for optimizing a SQL query |
| explain_query | Explain what a SQL query does in plain English |
| generate_table_insights | Generate AI-powered insights about a table's data |