akb_sql
Execute SQL on vault tables for read and write operations. Prefix table names with vault names for cross-vault queries, with role-based access control requiring reader or writer permissions.
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.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | SQL query to execute | |
| vault | No | Single vault shorthand (instead of vaults array) | |
| vaults | No | Vault names whose tables are referenced (default: single vault) |