MCP Tools Reference

sql_query

Run a parameterized SQL query.

Parameter	Type	Required	Description
sql	string	✓	SQL statement
params	array		Positional parameters

sql_batch

Run multiple SQL statements.

Parameter	Type	Required	Description
statements	array	✓	Array of {sql, params} objects

document_find

Find documents matching a filter.

Parameter	Type	Required	Description
collection	string	✓	Collection name
filter	object		MQL filter expression
limit	number		Max results (default 100)
skip	number		Offset

document_insert

Insert a single document.

Parameter	Type	Required	Description
collection	string	✓	Collection name
document	object	✓	Document data

document_update

Update a document matching a filter.

Parameter	Type	Required	Description
collection	string	✓	Collection name
filter	object	✓	MQL filter
update	object	✓	Update operators ($set, $unset)

document_delete

Delete a document matching a filter.

Parameter	Type	Required	Description
collection	string	✓	Collection name
filter	object	✓	MQL filter

kv_get

Get a value by key.

Parameter	Type	Required	Description
key	string	✓	KV key

kv_set

Set a value with optional TTL.

Parameter	Type	Required	Description
key	string	✓	KV key
value	any	✓	Value to store
ttl	number		Expiry in seconds

vector_search

Semantic similarity search.

Parameter	Type	Required	Description
query	string	✓	Search query text
topK	number		Number of results (default 10)
filter	object		Metadata filter

health_check

Returns API health status. No parameters.