library/sqlite-vec

• wasi:filesystem Filesystem read/write

  ** (rw)

act:tools interface — expand a tool for its input schema.

• query Execute a read-only SQL query (SELECT) and return results as array of row objects

  Execute a read-only SQL query (SELECT) and return results as array of row objects

  Parameter	Type	Description
  sql*	string	SQL SELECT query to execute
  params	array | null	Query parameters as array (optional)

  Returns content.

• execute Execute a write SQL statement (INSERT, UPDATE, DELETE, CREATE TABLE, etc.)

  Execute a write SQL statement (INSERT, UPDATE, DELETE, CREATE TABLE, etc.)

  Parameter	Type	Description
  sql*	string	SQL statement to execute
  params	array | null	Statement parameters as array (optional)

  Returns content.

• list_tables List all tables in the SQLite database

  List all tables in the SQLite database

  No input parameters.

  Returns content.

• describe_table Get column names, types, and constraints for a table

  Get column names, types, and constraints for a table

  Parameter	Type	Description
  table*	string	Table name to describe

  Returns content.

• execute_batch Execute multiple SQL statements in a single transaction

  Execute multiple SQL statements in a single transaction

  Parameter	Type	Description
  sql*	string	SQL statements separated by semicolons

  Returns content.