> ## Documentation Index
> Fetch the complete documentation index at: https://learn.getodin.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Database Toolkit

> Connect to a SQL database and run queries, inspect schemas, and validate SQL from within a workflow.

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.

## Tools

### 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. |