Okf Sqlite

SQLite OKF Connector

This skill provides a Go-based CLI tool to convert SQLite database schemas and comments into Open Knowledge Format (OKF) bundles, and validate existing databases against OKF bundles.

When to Use

Use this skill when you need to:

1. Extract metadata, table structures, column definitions, and primary keys from a local SQLite database into a portable OKF bundle.
2. Verify that an existing SQLite database conforms to an OKF bundle definition.

Setup

The connector is written in Go and requires Go 1.24+ to build from source:

# Install the published binary (Go 1.24+) — no clone needed:
go install github.com/xSAVIKx/okf-skills/skills/okf-sqlite@v0.1.0

# …or build from a clone of the repository:
cd skills/okf-sqlite
go build -o okf-sqlite .

How to Use

1. Produce an OKF Bundle

Extract metadata from a SQLite database file and save it as an OKF bundle directory:

./okf-sqlite produce --db  --out  [--tables ] [--sample ] [--profile]

Parameters:

• --db (required): Path to the SQLite .db or .sqlite file.
• --out (required): Path to the directory where the OKF bundle will be generated.
• --tables (optional): Filter to extract only specific tables.
• --sample (optional): Embed up to N sample rows per table as a ## Sample section in each table doc (default 0 = none).
• --profile (optional): Compute per-column statistics (non-null, null, distinct, min, max) and embed a ## Data Profile section.

2. Ingest / Verify an OKF Bundle

Verify an existing SQLite database's schema against an OKF bundle, or bootstrap missing tables:

./okf-sqlite ingest --db  --bundle  [--sync]

Parameters:

• --db (required): Path to the SQLite database.
• --bundle (required): Path to the OKF bundle.
• --sync (optional): If provided, the tool will attempt to create any missing tables or columns defined in the OKF bundle.

3. Inspect the Schema (self-description)

Print a machine-readable JSON description of this skill's commands and flags (used by okf-mcp to expose the skill as an MCP tool):

./okf-sqlite schema

Source & license

This open-source skill is cataloged on AgentStack and links to its original source — we do not rehost the code.

• Author: xSAVIKx
• Source: xSAVIKx/okf-skills
• License: Apache-2.0
• Homepage: https://xsavikx.github.io/okf-skills/

Install and usage instructions live in the source repository linked above.