Database Tools for Agents

Database Integration

System Prompt Snippet

You must add it to the Agent system prompt:

The Database engine is **PostgreSQL**, format parameters accordingly.  

Use the tool `Get Base Schema` to load the entire database model (tables, columns, types, policies).  

**Important: Obtain the schema before any other operation by calling `Get Base Schema`!**

Mandatory Tool

Get Base Schema

Purpose: Fetch full schema so the agent understands available tables, fields, and rules.

Parameters

altaner_component_id (Hard-coded): {{[$vars].room.meta_data.components.base.id}}

base_id (Hard-coded)

Read Operations

You must add the tools below when the agent capabilties require from reading tables.

Query Records

Purpose: Retrieve rows from a specific table.

Parameters

base_id (Hard-coded)

path (Agent): Target table name -- {type: "ai", value: null}

Filter Conditions (Agent): WHERE clause filters -- {type: "ai", value: null}

Columns Selection (Agent): List of fields to return -- {type: "ai", value: null}

Write Operations

Create Records

You must add the tools below when the agent capabilities require from write rows (records) to the database.

Purpose: Insert new rows into a table.

Parameters

base_id (Hard-coded)

path (Agent): Target table name

body (Agent): JSON payload of column-value pairs

The Base ID Parameter

The base_id paramater identifies the Database. Use the action get_project to obtain it if not in context.

Database Tools for Agents

Database Integration#

System Prompt Snippet#

Mandatory Tool#

Read Operations#

Write Operations#

The Base ID Parameter#

Database Integration

System Prompt Snippet

Mandatory Tool

Read Operations

Write Operations

The Base ID Parameter