sql-agent

The agent inspects database schemas and validates generated SQL queries before execution. It enforces read-only SELECT operations with explicit LIMIT clauses and requires human-in-the-loop approval prior to any data access, ensuring safe database exploration.

Yes, you can discover available data structures by listing tables and viewing relevant table DDL schemas through natural language prompts. The agent handles schema inspection and query generation, enabling database exploration without writing SQL code manually.

The agent supports only read-only SELECT operations and does not execute write, update, or delete queries. It enforces explicit LIMIT clauses and requires human approval prior to data access to preserve data integrity during database exploration.

Human-in-the-loop approval requires explicit user authorization before the agent executes any generated SQL query. The agent validates the query, enforces read-only SELECT with LIMIT, and pauses for human approval prior to accessing the database.

The best approach is to use a query checker to validate generated SQL against the database schema before execution. This ensures the natural language translation produces syntactically correct, read-only SELECT queries with explicit LIMIT clauses prior to human approval.