akb_sql
Execute SQL queries on vault tables with role-based access control. Supports cross-vault queries by prefixing table names (e.g., sales__pipeline). Use LIMIT to cap returned rows and avoid large responses.
Instructions
Execute SQL on vault tables. Tables are real PostgreSQL tables. Use table names directly (e.g. 'pipeline', 'partners') — they are auto-resolved to the vault's tables. For cross-vault queries, list all vaults in the vaults parameter. Prefix table names with vault name for cross-vault: sales__pipeline, external_projects__partners. SELECT requires reader role. INSERT/UPDATE/DELETE requires writer role. Add a LIMIT to SELECTs unless you truly need every row — the full result set is returned (nothing is silently truncated), so an unbounded SELECT on a large table can send back a very large response.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | SQL query to execute. For large tables, add a LIMIT to cap the rows returned unless you need the full set. | |
| vault | No | Single vault shorthand (instead of vaults array) | |
| vaults | No | Vault names whose tables are referenced (default: single vault) | |
| _vault_skill_ack | No | Opaque acknowledgement returned as vault_skill.ack_token. After applying that guide, retry the unchanged operation with this value. The bundled proxy supplies it automatically. |