Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| DATABASE_URI | Yes | The PostgreSQL database connection URI |
Schema
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| list_schemas | List all schemas in the database |
| list_objects | List objects in a schema |
| get_object_details | Show detailed information about a database object |
| explain_query | Explains the execution plan for a SQL query, showing how the database will execute it and provides detailed cost estimates. |
| analyze_workload_indexes | Analyze frequently executed queries in the database and recommend optimal indexes |
| analyze_query_indexes | Analyze a list of (up to 10) SQL queries and recommend optimal indexes |
| analyze_db_health | Analyzes database health. Here are the available health checks:
|
| get_top_queries | Reports the slowest SQL queries based on execution time, using data from the 'pg_stat_statements' extension. |
| execute_sql | Execute any SQL query |