Teradata SQL Agent

The Teradata SQL Agent provides an intelligent interface for interacting with Teradata databases. It translates natural language questions into optimized SQL queries, handles secure connections, and processes complex analytical queries while maintaining Teradata-specific optimizations.

Teradata SQL Agent workflow and architecture

Configuration Parameters

Required Input Parameters

host: Teradata server hostname or IP address
username: Database authentication username
password: Database authentication password
database: Target database name
question: Natural language query to be processed

Optional Configuration

llm: Language model configuration
- model_name: Name of the language model
- temperature: Response creativity (0-1)
- max_tokens: Maximum response length
connection_params: Additional connection parameters
- port: Database port (default: 1025)
- logmech: Login mechanism
- timeout: Connection timeout

Output Format

{
  "query": {
    "sql": string,
    "parameters": object,
    "execution_time": number
  },
  "response": {
    "results": array,
    "column_info": [
      {
        "name": string,
        "type": string,
        "nullable": boolean
      }
    ],
    "row_count": number,
    "metadata": {
      "database": string,
      "schema": string,
      "timestamp": string
    }
  },
  "performance_metrics": {
    "cpu_time": number,
    "io_time": number,
    "total_time": number,
    "rows_examined": number
  }
}

Features

Natural language to Teradata SQL translation
Query optimization for Teradata
Secure connection handling
Performance monitoring
Schema awareness
Error handling and recovery
Query execution metrics
Result set formatting

Note: Ensure proper database access permissions and consider using connection pooling for better performance in production environments. Implement appropriate security measures for credential management.

Tip: Utilize Teradata-specific optimization techniques like partitioned primary indexes and join indexes for better query performance. Monitor query execution plans for optimal performance.

Example Usage

const teradataAgent = new TeradataSQLAgent({
  host: "teradata.example.com",
  username: "analyst",
  password: "****",
  database: "sales_db",
  llm: {
    model_name: "gpt-4",
    temperature: 0.3
  }
});

const response = await teradataAgent.query({
  question: "What were the total sales by region for last quarter?",
  connection_params: {
    logmech: "LDAP",
    timeout: 300
  }
});