Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| SSE | No | Boolean to determine if your server will be using the SSE transport (SSE = True) or the stdio transport (SSE=False) | False |
| SSE_HOST | No | IP address that the server can be found at | 127.0.0.1 |
| SSE_PORT | No | Port address that the server can be found at | 8001 |
| DATABASE_URI | Yes | The database URI in the format teradata://username:password@host:1025/databasename | |
| OPENAI_API_KEY | No | OpenAI API key for LLM credentials | |
| aws_region_name | No | AWS region name for LLM credentials | |
| aws_access_key_id | No | AWS access key ID for LLM credentials | |
| aws_session_token | No | AWS session token for LLM credentials | |
| aws_secret_access_key | No | AWS secret access key for LLM credentials |
Schema
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
| sql_prompt | Create a SQL query against the database |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| execute_read_query | Executes a SQL query to read from the database. |
| execute_write_query | Executes a SQL query to write to the database. |
| read_table_ddl | Display table DDL definition. |
| read_database_list | List all databases in the Teradata System. |
| read_table_list | List objects in a database. |
| read_column_description | Show detailed column information about a database table. |
| read_table_preview | Get data samples and structure overview from a database table. |
| read_table_affinity | Get tables commonly used together by database users, this is helpful to infer relationships between tables. |
| read_table_usage | Measure the usage of a table and views by users in a given schema, this is helpful to infer what database objects are most actively used or drive most value. |
| read_SQL_list | Get a list of SQL run by a user in the last number of days if a user name is provided, otherwise get list of all SQL in the last number of days. |
| read_table_space | Get table space used for a table if table name is provided or get table space for all tables in a database if a database name is provided. |
| read_database_space | Get database space if database name is provided, otherwise get all databases space allocations. |
| read_database_version | Get Teradata database version information. |
| read_resusage_summary | Get the Teradata system usage summary metrics by weekday and hour for each workload type and query complexity bucket. |
| read_missing_columns | Get the column names that having missing values in a table. |
| read_negative_columns | Get the column names that having negative values in a table. |
| read_destinct_categories | Get the destinct categories from column in a table. |
| read_standard_deviation | Get the standard deviation from column in a table. |