db_query
Run SQL queries with role-based permissions, enforcing read, write, and delete restrictions across PostgreSQL, MySQL, and SQLite databases.
Instructions
Run a SQL query. SELECT/SHOW requires db.read. INSERT/UPDATE requires db.write.. DELETE/DROP requires db.danger.. Supports PostgreSQL, MySQL, SQLite.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| query | Yes | SQL query to execute | |
| database | No | Database URL (optional, uses GUARD_DB_URL env var if not provided) |