Data · stdio · opencode
SQLite
Query the ops database directly.
Available
stdio
6 tools
What it does
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
| Tool | Description |
|---|---|
| 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
Opens one configured database file. Writes are possible; prefer the sqlite3 CLI with a backup first.