Catalog/ Data/ SQLite
Data · stdio · opencode

SQLite

Query the ops database directly.

Available stdio 6 tools

What it does

summary

Reads schema, runs SELECT statements and lists tables in the local ops database.

Talk to a database or cache. Connection strings stay in the client environment, never in this registry.

Tools

6 documented
SQLite tool surface
ToolDescription
read_query Execute a SELECT query on the SQLite database
write_query Execute an INSERT, UPDATE, or DELETE query on the SQLite database
create_table Create a new table in the SQLite database
list_tables List all tables in the SQLite database
describe_table Get the schema information for a specific table
append_insight Add a business insight to the memo

Install / connect

mcp-server-sqlite --db-path ~/.config/opencode/data/ops.db

Client-side configuration. Secrets and connection strings belong in your own environment, never in this registry.

Safety

rules

Opens one configured database file. Writes are possible; prefer the sqlite3 CLI with a backup first.