opencode-db
CLI for OpenCode's local database. OpenCode saves every agent session, conversation, token usage, and cost in a local SQLite file. This tool lets you inspect, export, analyze, and clean up that data.
pip install opencode-db
# recommended if your system python3 is older than 3.12:
uv tool install opencode-db
Quick start
opencode-db --version # installed version
opencode-db list # recent sessions
opencode-db directories # launch directories, including missing ones
opencode-db view # interactive session viewer (colored, scrollable)
opencode-db stats # database summary
opencode-db schema # detect v1/v2 schema
opencode-db costs --total # total token costs
opencode-db export # export dialog to .md (interactive)
opencode-db help # full reference
Features
view— просмотр сессии в терминале с ANSI-цветами, Markdown-рендерингом и прокруткой черезlesslist/info/search/tree— навигация и поиск по сессиямdirectories(dirs) — все директории запусков, включая отсутствующие;list --directoryдобавляет путь к сессииexport— экспорт диалога в Markdown (с поддержкой Obsidian)delete/prune— удаление и массовая очистка с фильтрами;prune --missing-directories— защищённая очистка сессий из отсутствующих путейcosts/stats— аналитика токенов и расходовschema— определяет v1/v2-схему OpenCode, миграции и доступные операции--db-path/OPENCODE_DB— кастомный путь к БД
Optional extras
pip install opencode-db[rich] # enhanced Markdown rendering (recommended)
pip install opencode-db # zero external dependencies
Requirements
- Python 3.12+ — the CLI checks the interpreter at startup and exits with a clear message instead of an
ImportErroron older versions - OpenCode (must have been run at least once)
- macOS / Linux
Directory support: global is a synthetic project for non-Git directories; directories shows the real session.directory and marks it as Global (no project root). Missing paths are detected with os.path.isdir() at command runtime and can be filtered with --missing.
Schema support: OpenCode 1.19.x (v1) — read and write; OpenCode 2.x preview (v2) — read-only. Run opencode-db schema to check the detected schema. On v2, delete, prune, and vacuum are refused until write support is implemented.
1 maintainer
Metadata
1 maintainer
Release files for opencode-db 0.9.0
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | Provenance | |
|---|---|---|---|---|
| opencode_db-0.9.0.tar.gz | 80.8 kB | With provenance | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| opencode_db-0.9.0-py3-none-any.whl | Python 3 | none | any | Details |
Total release size: 154.1 kB
Release files / opencode_db-0.9.0.tar.gz
| Download URL | opencode_db-0.9.0.tar.gz |
|---|---|
| Size | 80.8 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
f5c72c92c2d1ed1b06916b49da42a75abea7fbb1368f8174a40ff1d794fa6849
|
|
BLAKE2b-256 checksum How to use checksums |
ddab4f7576fc2ab16509729c514fcc38e925772d4b25cfdfb947fc805a06ed1f
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
Yes |
| Uploaded via |
twine/7.0.0 CPython/3.13.14
|
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
PyPI Publish Attestation
PyPI verified that this artifact, at this checksum, originated from the publisher listed below.
Signed by GitHub Actions, verified by PyPI on Oct 20, 2026.
Transparency logRelease files / opencode_db-0.9.0-py3-none-any.whl
| Download URL | opencode_db-0.9.0-py3-none-any.whl |
|---|---|
| Size | 73.3 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
1ece7eba6b23d2def9b5b9317b44f9e15df965ddb9072102a4d4bc05cb99621e
|
|
BLAKE2b-256 checksum How to use checksums |
6799ae9b59771151028f9f320c0e20891aef1e1f5d8ca5d8ee0c4cfb43275e19
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
Yes |
| Uploaded via |
twine/7.0.0 CPython/3.13.14
|
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
PyPI Publish Attestation
PyPI verified that this artifact, at this checksum, originated from the publisher listed below.
Signed by GitHub Actions, verified by PyPI on Oct 20, 2026.
Transparency logSecurity for opencode-db 0.9.0
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
Full provenance
All 2 files in this release have been uploaded with provenance metadata.
Attestation for opencode_db-0.9.0.tar.gz
PyPI Publish Attestation
PyPI verified that this artifact, at this checksum, originated from the publisher listed below.
Signed by GitHub Actions, verified by PyPI on Oct 20, 2026.
Transparency logA note on package security
PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.
