Skip to content

Integration Tasks

Query, insert, and delete from LanceDB tables. Requires a lancedb resource.

- name: list-users
type: call:lancedb
resource: a3t/a3t-platform-db
config:
operation: query
table: users
filter: "org_id = '${ .org_id }'"
select: [id, name, email, role]
limit: 100
- name: create-user
type: call:lancedb
resource: a3t/a3t-platform-db
config:
operation: insert
table: users
records:
- id: "${ .data.id }"
name: "${ .data.name }"
email: "${ .data.email }"
created_at: "${ .timestamp }"
- name: remove-user
type: call:lancedb
resource: a3t/a3t-platform-db
config:
operation: delete
table: users
filter: "id = '${ .id }'"

Execute SQL queries against PostgreSQL or MySQL. Requires a postgres or mysql resource.

- name: query-orders
type: call:sql
resource: my-postgres
config:
query: "SELECT * FROM orders WHERE status = $1 LIMIT $2"
params: ["${ .status }", "${ .limit }"]

Vector database operations. Requires a qdrant resource.

- name: search-similar
type: call:qdrant
resource: my-qdrant
config:
operation: search
collection: documents
vector: "${ .embedding }"
limit: 5
filter:
must:
- key: category
match:
value: "${ .category }"

Execute AQL (Agent Query Language) against ClawDB for memory operations.

- name: recall-context
type: call:clawdb
resource: agent-memory
config:
query: 'RECALL FROM EPISODIC WHERE content = "${ .query }" LIMIT 5'

Call a tool on an MCP server. Requires an mcp resource.

- name: run-tool
type: call:mcp
resource: my-mcp-server
config:
tool: list_resources
arguments:
namespace: default