A procedure for rebuilding the SQLite database from a legacy Confluence HTML export of RouterOS documentation. RouterOS is MikroTik’s operating system for network devices.

Use it to run the legacy HTML extraction pipeline for one version or all available versions. It is not the procedure for migrating the newer MikroTik manual.

It provides a repeatable way to refresh the old documentation database after schema changes or when new RouterOS versions are available.

re-extract — Skill for Claude Code and Codex by tikoci: A procedure for rebuilding the SQLite database from a…

Install

Getting it into your agent

One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.

agentmods

npx agentmods add skills/tikoci/rosetta/re-extract

Any agent

npx skills add tikoci/rosetta --skill re-extract

Clone the repo

git clone --depth 1 https://github.com/tikoci/rosetta

Made for: Claude Code, Codex.

Wrote this? Show the measurements

A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.

README.md

[![agentmods](https://agentmods.dev/badge/skills/tikoci/rosetta/re-extract.svg)](https://agentmods.dev/skills/tikoci/rosetta/re-extract)

Your own site

<a href="https://agentmods.dev/skills/tikoci/rosetta/re-extract"><img src="https://agentmods.dev/badge/skills/tikoci/rosetta/re-extract.svg" alt="Measured on agentmods" height="20"></a>

Per session 40 Skills are progressive disclosure: only the name and description are preloaded; the body loads when the skill is used.

When invoked 580 The whole file, excluding the scripts and references it only reads on demand.

Security scan A 0 findings. Scan, not verified.

Origin original No closer match found in the catalogue.

Token cost

What it costs to keep this loaded

Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.

Model	Per session	Once invoked
Fable 5	$0.00040	$0.00580
Opus 5	$0.00020	$0.00290
Sonnet 5	$0.00008	$0.00116
Haiku 4.5	$0.00004	$0.00058

Measured 4d ago against content hash ed584a199315, method: parsed. Prices are Anthropic first-party input rates as of 2026-08-30, from the pricing page.

Security

Grade A, and why

re-extract scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 4d ago.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Nothing flagged

None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.

.github/skills/re-extract/SKILL.md · 66 lines

How it starts

The opening of the file, as written. The whole thing — 66 lines — stays where its author put it; the contents beside it link to each section on GitHub.

Re-extract Legacy Documentation Pipeline

When to Use

A legacy Confluence HTML export is available
Database needs rebuilding from scratch
Schema changes require fresh extraction
New RouterOS versions available in restraml GitHub Pages

Do not use this skill as the migration path for https://manual.mikrotik.com. MikroTik's new Docusaurus manual and CLI Reference require extractor and MCP/TUI result-shape redesign; read DESIGN.md and briefings/B-0012-docusaurus-manual-migration.md first.

Procedure

Verify prerequisites
- Bun is installed: bun --version
- Dependencies installed: bun install
- Legacy HTML export exists in box/documents-export-*/ROS/
- For commands: internet access to https://tikoci.github.io/restraml/ (or provide a local docs path explicitly)
Clean existing database
```
make clean
```
Run full pipeline (choose one)

Single version (fast, latest stable only):
```
make extract
```
All versions (slower, all 46 RouterOS versions):
```
make extract-full
```
Pipeline order:
- extract-html — HTML → pages + callouts tables
- extract-properties — Property tables from HTML → properties table
- extract-commands or extract-all-versions — inspect.json → commands + ros_versions + command_versions
- link — command ↔ page mapping
Verify results
```
make search query="firewall filter"
```
Expected counts (full pipeline):
- ~317 pages, ~4860 properties, ~1034 callouts
- ~40K commands (primary version), ~1.67M command_versions
- 46 ros_versions, ~92% dir link coverage
Validate with type check and lint
```
bun run typecheck && make lint
```

Troubleshooting

If HTML directory changed, update HTML_DIR in the root Makefile
If using offline/local data, pass explicit source paths to extract-commands.ts or extract-all-versions.ts
Each extractor is idempotent — safe to re-run individually
FK deletion order matters: callouts → properties → pages

Read the full file on GitHub · 66 lines

Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

4d ago First seen · 66 lines · 40 tokens per session scan A ed584a199315

Subscribe to this mod's changes

re-extract is a skill published in the GitHub repository tikoci/rosetta (43 stars, last pushed 18d ago), licensed MIT. It adds 40 tokens to every session and 580 once invoked, about $0.0002 per session on Opus 5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-08-30.

Databases Documents ai bun claude-code copilot mcp mcp-server

carta-consolidating-balance-sheet

Generate a consolidating Balance Sheet for all entities under a firm for a given month and write it as a side-by-side Excel tab with Assets / Liabilities / Equity sections and a Total column. Sourced from Carta MCP (firm/entity resolution + DWH SQL). TRIGGER when the user asks for "balance sheet of all entities of…

carta/plugins · 209 tokens

exasol-import-export

Exasol IMPORT and EXPORT SQL statements: syntax, file formats (CSV, FBV, Parquet), cloud storage (S3, Azure, GCS), connection objects, error handling, and ETL staging patterns.

exasol/mcp-server · 49 tokens

intro-page-updater

Update the public TogoMCP intro/landing page at togomcp/data/docs/togomcp-intro.html whenever the catalog of databases, the catalog of MCP tools, or any other surface fact shown on the page changes. Trigger when the user adds/removes/renames a database (MIE file, endpoints.csv row), adds/removes/renames a tool (any…

dbcls/togomcp · 229 tokens

nextcloud-ingest

Natively ingest Nextcloud files into the epistemic-graph knowledge graph via the nextcloud-agent MCP server — fetch a file over WebDAV and store its raw bytes as a content-addressed :Blob/:AssetOccurrence plus its extracted text (pdf/office/txt or image OCR) as a linked :Document. Use when the agent must make a…

Knuckles-Team/nextcloud-agent · 122 tokens

junta-leiloeiros

Coleta e consulta dados de leiloeiros oficiais de todas as 27 Juntas Comerciais do Brasil. Scraper multi-UF, banco SQLite, API FastAPI e exportacao CSV/JSON.

beel-collab/presets.dev · 42 tokens

mongodb

MongoDB document database patterns, schema design, indexing, and aggregation.

Plazmodium/odin-workflow · 15 tokens