菜单
MySQL connector that produces and ingests Open Knowledge Format (OKF) bundles from database schemas and table/column comments. Use when documenting or cataloging a MySQL database, extracting its schema and comments into OKF, or syncing descriptions back to MySQL via DDL.
用 Codex 或 Claude 帮你安装 复制这段 Prompt，粘贴到 Codex、Claude 或其他助手里，让它检查 Skill 页面并帮你完成安装。
基于 SOC 职业分类
Generic Model Context Protocol (MCP) server that discovers installed okf-* skill binaries and exposes their produce/ingest commands as MCP tools for any MCP-capable harness (Claude Code, Gemini CLI, etc.). Use when wiring OKF Skills into an agent over MCP instead of invoking each connector binary directly.
Google Cloud BigQuery connector that produces and ingests Open Knowledge Format (OKF) bundles from dataset schemas, table/field descriptions, and metadata. Use when documenting or cataloging BigQuery datasets, extracting schema metadata into OKF, or syncing descriptions back to BigQuery tables and fields.
CSV connector that produces and ingests Open Knowledge Format (OKF) bundles from a directory of CSV files. Infers each file's column schema (integer/number/boolean/date/string) by sampling rows, optionally embeds a per-column data profile and sample rows, and syncs descriptions back to a .okf-metadata.yaml sidecar. Use when documenting or cataloging a folder of CSV/flat files, or capturing their inferred schema and stats as an OKF bundle. CGO-free, pure Go.
Local filesystem connector that produces and ingests Open Knowledge Format (OKF) bundles documenting directory trees and file metadata, honoring .okfignore and .okf-metadata.yaml. Use when documenting or cataloging a local folder structure, or capturing filesystem metadata as an OKF bundle.
Git repository connector that produces and ingests Open Knowledge Format (OKF) bundles documenting repository file trees plus commit-history metadata (times, authors, messages), honoring .gitignore and .okfignore. Use when documenting or cataloging a Git repository as an OKF bundle.
GraphQL connector that produces and ingests Open Knowledge Format (OKF) bundles from a GraphQL SDL document. Parses the schema into one concept per user-defined type (object/input/interface/enum/union) and per root operation (query/mutation/subscription field), links fields and operations to the types they reference as native relationship edges, and syncs descriptions back to a .okf-metadata.yaml sidecar. Use when documenting or cataloging a GraphQL API from its schema, with no live server. Pure Go.
| name | okf-mysql |
| description | MySQL connector that produces and ingests Open Knowledge Format (OKF) bundles from database schemas and table/column comments. Use when documenting or cataloging a MySQL database, extracting its schema and comments into OKF, or syncing descriptions back to MySQL via DDL. |
| license | Apache-2.0 |
| compatibility | Requires the Go toolchain (1.24+) to build the connector binary, plus network access and credentials for the target MySQL database. |
| metadata | {"version":"0.8.0","author":"Yurii Serhiichuk","tags":"okf, knowledge-catalog, mysql, database, schema, documentation"} |
This skill provides a Go-based CLI tool to convert MySQL database schemas and comments (table and column comments) into Open Knowledge Format (OKF) bundles, and synchronize comments back to a MySQL database from an OKF bundle.
Use this skill when you need to:
The connector requires Go 1.24+:
# Install the published binary (Go 1.24+) — no clone needed:
go install github.com/xSAVIKx/okf-skills/skills/okf-mysql@v0.1.0
# …or build from a clone of the repository:
cd skills/okf-mysql
go build -o okf-mysql .
Extract database schema metadata and comments:
./okf-mysql produce --host <host> --port <port> --user <user> --password <password> --db <database-name> --out <output-bundle-dir> [--tables <comma-separated-table-names>] [--sample <N>] [--profile]
Synchronize table/column descriptions from the OKF bundle back into database comments:
./okf-mysql ingest --host <host> --port <port> --user <user> --password <password> --db <database-name> --bundle <path-to-okf-bundle> [--sync]
Parameters:
--host (default localhost): MySQL host.--port (default 3306): MySQL port.--user (required): MySQL user.--password (required): MySQL password. May also be supplied via the MYSQL_PASSWORD environment variable to keep secrets out of the command line.--db (required): Target database schema.--bundle (required for ingest): Path to the OKF bundle.--out (required for produce): Path to output OKF bundle.--tables (optional): Filter to extract only specific tables.--sample <N> (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.--sync (optional for ingest): If provided, runs ALTER TABLE ... COMMENT = ... and MODIFY COLUMN ... COMMENT ... statements to synchronize descriptions.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-mysql schema