Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| PG_HOST | No | PostgreSQL host | localhost |
| PG_PORT | No | PostgreSQL port | 5432 |
| PG_USER | No | Default username | |
| PG_DATABASE | No | Default database name | |
| PG_PASSWORD | No | Default password |
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 |
|---|---|
| connect_database | Connect to a PostgreSQL database |
| list_tables | List all tables in the current database |
| describe_table | Get detailed information about a table's structure, columns, and constraints |
| execute_query | Execute a read-only SQL query (SELECT, SHOW, DESCRIBE, EXPLAIN, WITH statements only) |
| get_schema | Get an overview of the database schema including tables and their relationships |
| disconnect_database | Disconnect from the current PostgreSQL database |