Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| POOL_MAX | No | Maximum connections in pool | 10 |
| POOL_MIN | No | Minimum connections in pool | 2 |
| CACHE_TTL | No | Cache TTL in milliseconds | 300000 |
| LOG_LEVEL | No | Logging level (error|warn|info|debug) | info |
| SQL_LOGGING | No | Log SQL queries | false |
| DATABASE_URL | No | PostgreSQL connection string in format postgresql://username:password@localhost:5432/dbname | |
| POSTGRES_SSL | No | Enable SSL connection | false |
| CACHE_ENABLED | No | Enable query result caching | true |
| POSTGRES_HOST | No | PostgreSQL host | |
| POSTGRES_PORT | No | PostgreSQL port | |
| POSTGRES_USER | No | PostgreSQL username | |
| POOL_IDLE_TIMEOUT | No | Idle timeout in milliseconds | 30000 |
| POSTGRES_DATABASE | No | PostgreSQL database name | |
| POSTGRES_PASSWORD | No | PostgreSQL password | |
| POOL_ACQUIRE_TIMEOUT | No | Acquire timeout in milliseconds | 60000 |
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 | Execute SQL queries with transaction support, query analysis, and performance monitoring |
| tables | Table management: list, create, alter, drop tables and get detailed table information |
| schemas | Schema management: list, create, drop schemas and manage schema permissions |
| indexes | Index management: list, create, drop indexes and analyze index usage |
| data | Data operations: insert, update, delete, bulk operations with validation |
| transactions | Transaction management: begin, commit, rollback, savepoints |
| admin | Database administration: users, permissions, database info, maintenance operations |
| monitoring | Database monitoring: performance metrics, statistics, health checks |
| connections | Connection pool management: status, statistics, configuration |
| permissions | Database permissions management: users, roles, grants, privileges |
| security | Database security management: SSL, authentication, encryption, auditing |