Agentuity Documentation

Execute queries, inspect tables, and monitor database performance.

Region

https://catalyst-usw.agentuity.cloud

Authentication

All requests require a Bearer token. Pass your SDK key in the Authorization header.

Header	Value
`Authorization`	`Bearer YOUR_SDK_KEY`

You can find your SDK key in the Agentuity Console under your project settings.

Get Query Logs

Get query logs for a database with optional filtering.

GET/resource/{orgId}/{region}/{database}/logs

https://catalyst-usw.agentuity.cloud/resource/{orgId}/{region}/{database}/logs

Parameters

path

Name	Type	Required	Description
`orgId`	string	Yes	Organization ID
`region`	string	Yes	Region identifier
`database`	string	Yes	Database name

query

Name	Type	Required	Description
`startDate`	string	No	Start date filter
`endDate`	string	No	End date filter
`username`	string	No	Filter by username
`command`	string	No	Filter by SQL command type
`hasError`	boolean	No	Filter for queries with errors
`sessionId`	string	No	Filter by session ID
`limit`	number	No	Maximum logs to return

Response

Array of query log entries.

Status	Description
200	Query logs returned
401	Unauthorized — invalid or missing Bearer token
404	Database not found

Example

curl -X GET 'https://catalyst-usw.agentuity.cloud/resource/org_abc123/usw/mydb/logs' \
  -H 'Authorization: Bearer $AGENTUITY_SDK_KEY'

Execute Query

Execute a SQL query against a database.

POST/resource/{orgId}/{region}/{database}/query

https://catalyst-usw.agentuity.cloud/resource/{orgId}/{region}/{database}/query

Parameters

path

Name	Type	Required	Description
`orgId`	string	Yes	Organization ID
`region`	string	Yes	Region identifier
`database`	string	Yes	Database name

Request Body

SQL query payload.

Field	Type	Description
`query`	string	SQL query to execute

Response

Returns columns, rows, row count, and whether results were truncated (max 1000 rows).

Status	Description
200	Query executed successfully
401	Unauthorized — invalid or missing Bearer token
404	Database not found

Example

curl -X POST 'https://catalyst-usw.agentuity.cloud/resource/org_abc123/usw/mydb/query' \
  -H 'Authorization: Bearer $AGENTUITY_SDK_KEY' \
  -H 'Content-Type: application/json' \
  -d '{
  "query": "SELECT * FROM users LIMIT 10"
}'

Get Query Stats

Get aggregate query statistics for a database over a date range.

GET/resource/{orgId}/{region}/{database}/logs/stats

https://catalyst-usw.agentuity.cloud/resource/{orgId}/{region}/{database}/logs/stats

Parameters

path

Name	Type	Required	Description
`orgId`	string	Yes	Organization ID
`region`	string	Yes	Region identifier
`database`	string	Yes	Database name

query

Name	Type	Required	Description
`startDate`	string	Yes	Start date for stats range
`endDate`	string	Yes	End date for stats range

Response

Aggregate query statistics.

Status	Description
200	Query stats returned
401	Unauthorized — invalid or missing Bearer token
404	Database not found

Example

curl -X GET 'https://catalyst-usw.agentuity.cloud/resource/org_abc123/usw/mydb/logs/stats' \
  -H 'Authorization: Bearer $AGENTUITY_SDK_KEY'

List Tables

List all tables in a database.

GET/resource/{orgId}/{region}/{database}/tables

https://catalyst-usw.agentuity.cloud/resource/{orgId}/{region}/{database}/tables

Parameters

path

Name	Type	Required	Description
`orgId`	string	Yes	Organization ID
`region`	string	Yes	Region identifier
`database`	string	Yes	Database name

Response

Array of table names and metadata.

Status	Description
200	Tables returned
401	Unauthorized — invalid or missing Bearer token
404	Database not found

Example

curl -X GET 'https://catalyst-usw.agentuity.cloud/resource/org_abc123/usw/mydb/tables' \
  -H 'Authorization: Bearer $AGENTUITY_SDK_KEY'