AI Tools

This topic describes global settings for AI access to database data and schema. When enabled, these settings allow AI agents and LLMs to read or modify database data and schema in all databases without confirmation.

These permissions can be required for the database-specific tools to work properly.

Read database data

Allows running commands that read database data, and send the results to an AI agent. For example, the client can run SELECT queries.

Modify database data

Allows modifying data in all databases. For example, the client can insert, update, or delete data using INSERT, UPDATE, or DELETE statements, or modify data by calling routines.

Read database schemas

Allows reading the structure of database schemas in all databases.

Enabling this setting improves query generation quality. It also results in higher quota consumption.

Modify database schemas

Allows modifying the structure of database schemas in all databases. For example, the client can create, alter, or delete schema objects using CREATE, ALTER, or DROP statements.