Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| DEBUG | No | Debug settings | |
| NODE_ENV | No | Environment setting (development/production) | |
| POSTGRES_DB | No | PostgreSQL database name | |
| DATABASE_URL | No | PostgreSQL connection string | |
| POSTGRES_HOST | No | PostgreSQL host | |
| POSTGRES_PORT | No | PostgreSQL port | |
| POSTGRES_USER | No | PostgreSQL username | |
| QUERY_TIMEOUT | No | Timeout for database queries in milliseconds | |
| MAX_CONNECTIONS | No | Maximum number of database connections | |
| POSTGRES_PASSWORD | No | PostgreSQL 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 |
|---|---|
| query-table | Query data from a specific table with filtering, pagination, and sorting. Supports WHERE conditions with exact matches, arrays (IN), and LIKE patterns. |
| get-schema | Get database schema information including tables, columns, data types, and optionally constraints. Useful for understanding database structure. |
| execute-query | Execute a parameterized SQL query with safety checks. Supports SELECT, INSERT, UPDATE, DELETE operations with parameter binding to prevent SQL injection. |
| insert-data | Insert new records into a table. Supports single or multiple records, conflict resolution (ignore/update), and returning inserted data. |
| update-data | Update existing records in a table. Requires WHERE conditions for safety. Supports complex WHERE clauses and returns updated records. |
| delete-data | Delete records from a table. Requires WHERE conditions for safety. Includes confirmation prompt for large deletions. |
| get-table-info | Get detailed information about a specific table including columns, constraints, indexes, and optionally statistics like row count and size. |
| connection-status | Check database connection status, view error details, and retry connection. Use retry: true to attempt reconnection when database is unavailable. |