Agent Capabilities
list-databases: List active database connections and sources.list-tables: List all tables in a target database.check-table-schema: Retrieve column names, data types, and value stores for a specific table.query: Execute SQL queries against a database to retrieve data rows.
Security Configuration
- Access Control: Configure the SQL agent with a read-only database user. Do not grant write, modify, or delete permissions.
Usage Examples
- Query Database:
@agent can you summarize all of the sales volume for May 2024 in the backend-office DB?
- Export Query Results (Requires
save-file skill): @agent can you grab the emails of the most recent 10 customers and save that to customer.csv?