kdeps-tools-sql_ops
v1.0.0Run SQL against a named connection in config.yaml sql_connections and return the rows or a change summary. Databases: PostgreSQL, MySQL/MariaDB, SQLite, SQL Server, Oracle. One statement (query + params), or several in one transaction (transaction + queries). Requires: connectionName.
set tools / shelf tools
LLM context: ~287 tokens when loaded (prompt or tool definition)
Where it runs
Part of the tools set, used in workflow and agent mode. What the model is told about each built-in tool: its description, usage notes and parameters. kdeps runs the tool itself.
- the agent loop builds the request
- the tool definitions are sent to the modeltools/sql_ops
- the model calls a tool
- kdeps runs it
- the result goes back to the model
Loaded by: kdeps (agent loop), /update, /settings, kdeps run, kdeps install, kdeps list, kdeps uninstall, kdeps update
In the code: kdeps (agent loop)agent.RegisterBuiltinToolsagent.definedAs
Install
A kdeps asset: installed with the first-run profile that includes its set, or the first time a command needs it, and updated without a new release.
Pin a version with kdeps install tools/sql_ops@<version>.
Contents
Run SQL against a named connection in config.yaml sql_connections and return the rows or a change summary. Databases: PostgreSQL, MySQL/MariaDB, SQLite, SQL Server, Oracle. One statement (query + params), or several in one transaction (transaction + queries). Requires: connectionName.
| Parameter | Type | Description |
|---|---|---|
| connectionName * | string | Name under sql_connections in ~/.kdeps/config.yaml |
| format | string | Rows shape: table (default), json or csv |
| maxRows | integer | Rows a SELECT returns at most. Default: KDEPS_SQL_MAX_ROWS, else 1000 |
| params | array | Placeholder values, in order - a JSON array |
| queries | array | Transaction statements: [{query, params}] or [{query, paramsBatch}] |
| query | string | One SQL statement. Placeholders may be $1, $N, ?, ?N, @pN or :N |
| timeout | string | Statement timeout as a Go duration or seconds. Default: KDEPS_SQL_TIMEOUT, else 30s |
| transaction | boolean | Run queries in one transaction. Default: false |
version: 1.0.0
description: 'Run SQL against a named connection in config.yaml sql_connections and return the rows or a change summary. Databases: PostgreSQL, MySQL/MariaDB, SQLite, SQL Server, Oracle. One statement (query + params), or several in one transaction (transaction + queries). Requires: connectionName.'
parameters:
connectionName:
type: string
description: Name under sql_connections in ~/.kdeps/config.yaml
required: true
format:
type: string
description: 'Rows shape: table (default), json or csv'
maxRows:
type: integer
description: 'Rows a SELECT returns at most. Default: KDEPS_SQL_MAX_ROWS, else 1000'
params:
type: array
description: Placeholder values, in order - a JSON array
queries:
type: array
description: 'Transaction statements: [{query, params}] or [{query, paramsBatch}]'
query:
type: string
description: One SQL statement. Placeholders may be $1, $N, ?, ?N, @pN or :N
timeout:
type: string
description: 'Statement timeout as a Go duration or seconds. Default: KDEPS_SQL_TIMEOUT, else 30s'
transaction:
type: boolean
description: 'Run queries in one transaction. Default: false'
Versions
| Version | Published | Status |
|---|---|---|
| 1.0.0 | 10/21/2026 | active |
Details
- Author
- kdeps
- License
- Apache-2.0
- Latest Version
- 1.0.0
- Published
- 10/21/2026