Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| DB_SSL | No | Use SSL connection (default: false) | false |
| DB_HOST | No | Database host | |
| DB_PORT | No | Database port | |
| DB_TYPE | No | Database type - 'postgresql' or 'mysql' | |
| DB_USER | No | Database user | |
| MYSQL_SSL | No | Use SSL connection for MySQL (default: false) | false |
| MYSQL_HOST | No | MySQL database host | |
| MYSQL_PORT | No | MySQL database port | |
| MYSQL_USER | No | MySQL database user | |
| DB_DATABASE | No | Database name | |
| DB_PASSWORD | No | Database password | |
| POSTGRES_SSL | No | Use SSL connection for PostgreSQL (default: false) | false |
| POSTGRES_HOST | No | PostgreSQL database host | |
| POSTGRES_PORT | No | PostgreSQL database port | |
| POSTGRES_USER | No | PostgreSQL database user | |
| MYSQL_DATABASE | No | MySQL database name | |
| MYSQL_PASSWORD | No | MySQL database password | |
| POSTGRES_DATABASE | No | PostgreSQL database name | |
| POSTGRES_PASSWORD | No | PostgreSQL database password |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| connect_database | Connect to a PostgreSQL or MySQL database. Parameters can be provided directly or loaded from environment variables. If no parameters are provided, will use environment variables (DB_TYPE, DB_HOST, DB_PORT, DB_DATABASE, DB_USER, DB_PASSWORD, DB_SSL). For PostgreSQL: POSTGRES_HOST, POSTGRES_PORT, etc. For MySQL: MYSQL_HOST, MYSQL_PORT, etc. |
| execute_query | Execute a SQL query on the connected database. Returns query results. |
| list_tables | List all tables in the connected database |
| describe_table | Get schema information for a specific table |
| disconnect_database | Disconnect from the current database |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |