Teradata SQL FAQs

Question 1

What types of SQL operations can I perform with this tool?

Accepted Answer

You can execute comprehensive SELECT queries, which return data as JSON with row counts and truncation flags. It also supports running DDL/DML statements like INSERT, UPDATE, and CREATE, inspecting database schemas (listing databases, tables, and column definitions), and validating SQL syntax with Teradata EXPLAIN.

Question 2

How does it ensure secure database connections?

Accepted Answer

The tool offers flexible and secure connection configurations. It supports various authentication methods like LDAP and KRB5, enables encryption for data in transit (`encryptdata`), and provides robust TLS options such as `sslmode=VERIFY-FULL` for enhanced security.

Question 3

What is Teradata SQL (tdsql-mcp) designed for?

Accepted Answer

Teradata SQL (tdsql-mcp) is an MCP server providing robust SQL tools for interacting with Teradata databases. It's specifically designed for seamless integration with AI agent frameworks, such as Claude Desktop, and any other MCP-compatible client, enabling intelligent database management.

Question 4

Can I prevent accidental write operations on my Teradata database?

Accepted Answer

Yes, for data protection, you can activate a read-only mode. By setting the `TD_READ_ONLY` environment variable to `true` or using the `--read-only` CLI flag, all DDL/DML statements (INSERT, UPDATE, CREATE, etc.) will be disabled, preventing unintended modifications.

Question 5

How does the tool handle large query results?

Accepted Answer

To manage token usage efficiently, `execute_query` defaults to a `max_rows=100` limit. If more rows are available, the result includes a `truncated: true` flag. You can increase the `max_rows` parameter or refine your SQL query with `TOP N` or `WHERE` clauses to fetch specific data.

Teradata SQL

Teradata SQL

主な機能

ユースケース

主な機能

ユースケース