Documentation Index
Fetch the complete documentation index at: https://ai-kb.automationanywhere.com/llms.txt
Use this file to discover all available pages before exploring further.
The Database Toolkit allows your workflows to interact with a SQL database — listing tables, retrieving schema information, executing queries, and validating SQL before running it.
Authentication
All Database tools require a SQL database connection. Each tool includes a Connection selector. If no connection is configured, go to Settings → Connectors to create one.
List Tables
Retrieves a list of all tables in the connected database.
| Field | Required | Description |
|---|
| Connection | Yes | Select a configured database connection. |
Table Info
Retrieves schema information for one or more tables in the connected database.
| Field | Required | Description |
|---|
| Connection | Yes | Select a configured database connection. |
| Table Names | Yes | Comma-separated list of table names to retrieve schema info for (e.g. users, orders). Type @ to select a variable. |
SQL Db Query
Executes a SQL query against the connected database.
| Field | Required | Description |
|---|
| Connection | Yes | Select a configured database connection. |
| SQL Query | Yes | The SQL query to execute. Supports SELECT (read), INSERT, UPDATE, DELETE (data modification), and CREATE, ALTER, DROP (schema changes). Type @ to use variables in the query. SELECT queries without a LIMIT clause are automatically limited to 100 rows. |
Query Checker
Validates a SQL query against the connected database without executing it.
| Field | Required | Description |
|---|
| Connection | Yes | Select a configured database connection. |
| Query | Yes | The SQL query to validate. Type @ to select a variable. |
