Sqlite Schema Design
fastrepl/anarlog
Design or review schemas for crates/cloudsync using SQLite Sync constraints, not generic SQLite advice.
Parse SQLite databases into structured JSON data. An agent skill from benchflow-ai/skillsbench.
Install Sqlite Map Parser
$ npx skills add benchflow-ai/skillsbench --skill sqlite-map-parser -a claude-codeProject install by default; add -g for ~/.claude/skills/.
$ gh skill install benchflow-ai/skillsbench sqlite-map-parser --agent claude-codeProject scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).
$ git clone --depth 1 https://github.com/benchflow-ai/skillsbench.git skills-src && mkdir -p .claude/skills && cp -r skills-src/tasks/civ6-adjacency-optimizer/environment/skills/sqlite-map-parser .claude/skills/sqlite-map-parser && rm -rf skills-srcUse ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.
Claude Code skills documentation · loads skills from .claude/skills/
Install the "sqlite-map-parser" agent skill from https://github.com/benchflow-ai/skillsbench/tree/main/tasks/civ6-adjacency-optimizer/environment/skills/sqlite-map-parser into .claude/skills/sqlite-map-parser/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "sqlite-map-parser", then confirm the skill loads.Claude Code copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$skill-installer install https://github.com/benchflow-ai/skillsbench/tree/main/tasks/civ6-adjacency-optimizer/environment/skills/sqlite-map-parserType this inside Codex. $skill-installer <name> installs a curated skill from openai/skills. The installer writes to $CODEX_HOME/skills (default ~/.codex/skills). Restart Codex if the skill does not show up.
$ npx skills add benchflow-ai/skillsbench --skill sqlite-map-parser -a codexProject install goes to .agents/skills/; add -g for ~/.codex/skills/.
$ gh skill install benchflow-ai/skillsbench sqlite-map-parser --agent codexProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/benchflow-ai/skillsbench.git skills-src && mkdir -p .agents/skills && cp -r skills-src/tasks/civ6-adjacency-optimizer/environment/skills/sqlite-map-parser .agents/skills/sqlite-map-parser && rm -rf skills-srcUse ~/.agents/skills/ instead of .agents/skills for a personal install.
Codex skills documentation · loads skills from .agents/skills/
Install the "sqlite-map-parser" agent skill from https://github.com/benchflow-ai/skillsbench/tree/main/tasks/civ6-adjacency-optimizer/environment/skills/sqlite-map-parser into .agents/skills/sqlite-map-parser/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "sqlite-map-parser", then confirm the skill loads.Codex copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add benchflow-ai/skillsbench --skill sqlite-map-parser -a cursorProject install goes to .agents/skills/; add -g for ~/.cursor/skills/.
$ gh skill install benchflow-ai/skillsbench sqlite-map-parser --agent cursorProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/benchflow-ai/skillsbench.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/tasks/civ6-adjacency-optimizer/environment/skills/sqlite-map-parser .cursor/skills/sqlite-map-parser && rm -rf skills-srcUse ~/.cursor/skills/ instead of .cursor/skills for a personal install.
Cursor skills documentation · loads skills from .cursor/skills/, .agents/skills/, .claude/skills/, .codex/skills/
Install the "sqlite-map-parser" agent skill from https://github.com/benchflow-ai/skillsbench/tree/main/tasks/civ6-adjacency-optimizer/environment/skills/sqlite-map-parser into .cursor/skills/sqlite-map-parser/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "sqlite-map-parser", then confirm the skill loads.Cursor copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gemini skills install https://github.com/benchflow-ai/skillsbench.git --path tasks/civ6-adjacency-optimizer/environment/skills/sqlite-map-parser--scope user (default) or --scope workspace; --path is the subfolder of the repo that holds the skill; --consent skips the security confirmation prompt.
$ npx skills add benchflow-ai/skillsbench --skill sqlite-map-parser -a gemini-cliProject install goes to .agents/skills/; add -g for ~/.gemini/skills/.
$ gh skill install benchflow-ai/skillsbench sqlite-map-parser --agent gemini-cliProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/benchflow-ai/skillsbench.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/tasks/civ6-adjacency-optimizer/environment/skills/sqlite-map-parser .gemini/skills/sqlite-map-parser && rm -rf skills-srcUse ~/.gemini/skills/ instead of .gemini/skills for a personal install, then run /skills reload.
Gemini CLI skills documentation · loads skills from .gemini/skills/, .agents/skills/
Install the "sqlite-map-parser" agent skill from https://github.com/benchflow-ai/skillsbench/tree/main/tasks/civ6-adjacency-optimizer/environment/skills/sqlite-map-parser into .gemini/skills/sqlite-map-parser/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "sqlite-map-parser", then confirm the skill loads.Gemini CLI copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gh skill install benchflow-ai/skillsbench sqlite-map-parserInstalls for Copilot at project scope by default; add --scope user for a personal install. Preview a skill first with gh skill preview. Needs GitHub CLI 2.90.0 or later (public preview).
$ npx skills add benchflow-ai/skillsbench --skill sqlite-map-parser -a github-copilotProject install goes to .agents/skills/; add -g for ~/.copilot/skills/.
$ git clone --depth 1 https://github.com/benchflow-ai/skillsbench.git skills-src && mkdir -p .github/skills && cp -r skills-src/tasks/civ6-adjacency-optimizer/environment/skills/sqlite-map-parser .github/skills/sqlite-map-parser && rm -rf skills-srcUse ~/.copilot/skills/ instead of .github/skills for a personal install. Commit .github/skills so cloud agent and code review can use it.
GitHub Copilot skills documentation · loads skills from .github/skills/, .claude/skills/, .agents/skills/
Install the "sqlite-map-parser" agent skill from https://github.com/benchflow-ai/skillsbench/tree/main/tasks/civ6-adjacency-optimizer/environment/skills/sqlite-map-parser into .github/skills/sqlite-map-parser/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "sqlite-map-parser", then confirm the skill loads.GitHub Copilot copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add benchflow-ai/skillsbench --skill sqlite-map-parser -a opencodeOpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.
$ gh skill install benchflow-ai/skillsbench sqlite-map-parser --agent opencodeProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/benchflow-ai/skillsbench.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/tasks/civ6-adjacency-optimizer/environment/skills/sqlite-map-parser .opencode/skills/sqlite-map-parser && rm -rf skills-srcUse ~/.config/opencode/skills/ instead of .opencode/skills for a personal install.
OpenCode skills documentation · loads skills from .opencode/skills/, .claude/skills/, .agents/skills/
Install the "sqlite-map-parser" agent skill from https://github.com/benchflow-ai/skillsbench/tree/main/tasks/civ6-adjacency-optimizer/environment/skills/sqlite-map-parser into .opencode/skills/sqlite-map-parser/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "sqlite-map-parser", then confirm the skill loads.OpenCode copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
Facts
- Skill name
sqlite-map-parser- GitHub stars
- 1.8k
- Token cost
- ~1k tokens
- SKILL.md length
- 169 words
- Files
- 1
- Skills in repo
- 180
- Repo updated
- First seen
- Licence
- Apache-2.0
At a glance
Parse SQLite databases into structured JSON data. An agent skill from benchflow-ai/skillsbench.
- Works in 4 steps: Explore the Schema → Understand Relationships → Extract and Transform → …
- Exploring unknown database schemas
- SKILL.md covers Step 1: Explore the Schema, Step 2: Understand Relationships, Step 3: Extract and Transform and Step 4: Output as Structured…, plus 2 more sections
- Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md
What it does
Sqlite Map Parser is an agent skill from benchflow-ai/skillsbench. Parse SQLite databases into structured JSON data. Use when exploring unknown database schemas, understanding table relationships, and extracting map data as JSON.
Its SKILL.md is about 1k tokens, which your agent loads only when the skill is triggered. It is a single SKILL.md file with no bundled scripts.
It sits in Databases, covering Database schema design. It works with SQLite. The repository describes itself as: SkillsBench evaluates how well skills work and how effective agents are at using them. The licence is Apache-2.0.
When your agent uses it
- Exploring unknown database schemas
- Understanding table relationships
- Extracting map data as JSON
Example prompts
- “/sqlite-map-parser”
Requirements
- Python 3
Workflow steps
4 steps, taken from the step headings in SKILL.md.
What it can do on your machine
Read from SKILL.md and the folder at commit 9a1f4dd. It shows what the files ask for, not the result of running them.
Tool permissions
Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.
From allowed-tools in the SKILL.md frontmatter.
Runs code
No scripts in the folder and no shell commands in SKILL.md (its code samples are sql, python and json).
From the folder's file list and the shell code blocks in SKILL.md.
Network
No URLs in SKILL.md.
From URLs in SKILL.md, links to its own repository left out.
Credentials
Names no API keys, tokens, secrets or passwords.
From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.
Context cost
Sqlite Map Parser loads about 1k tokens when it runs. Until then it costs about 45 tokens; SKILL.md has 169 words of instructions outside code blocks.
Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.
Safety
Auto-check passed
The automated check found no risky patterns in SKILL.md.
Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.
SKILL.md
The full file from benchflow-ai/skillsbench at commit 9a1f4dd, republished under its Apache-2.0 licence (© benchflow-ai). 169 words, ~1,040 tokens.
Download SKILL.mdSave it as
.claude/skills/sqlite-map-parser/SKILL.md (or your agent's skills folder).- name
- sqlite-map-parser
- description
- Parse SQLite databases into structured JSON data. Use when exploring unknown database schemas, understanding table relationships, and extracting map data as JSON.
SQLite to Structured JSON
Parse SQLite databases by exploring schemas first, then extracting data into structured JSON.
Step 1: Explore the Schema
Always start by understanding what tables exist and their structure.
List All Tables
SELECT name FROM sqlite_master WHERE type='table';Inspect Table Schema
-- Get column names and types
PRAGMA table_info(TableName);
-- See CREATE statement
SELECT sql FROM sqlite_master WHERE name='TableName';Find Primary/Unique Keys
-- Primary key info
PRAGMA table_info(TableName); -- 'pk' column shows primary key order
-- All indexes (includes unique constraints)
PRAGMA index_list(TableName);
-- Columns in an index
PRAGMA index_info(index_name);Step 2: Understand Relationships
Identify Foreign Keys
PRAGMA foreign_key_list(TableName);Common Patterns
ID-based joins: Tables often share an ID column
-- Main table has ID as primary key
-- Related tables reference it
SELECT m.*, r.ExtraData
FROM MainTable m
LEFT JOIN RelatedTable r ON m.ID = r.ID;Coordinate-based keys: Spatial data often uses computed coordinates
# If ID represents a linear index into a grid:
x = id % width
y = id // widthStep 3: Extract and Transform
Basic Pattern
import sqlite3
import json
def parse_sqlite_to_json(db_path):
conn = sqlite3.connect(db_path)
conn.row_factory = sqlite3.Row # Access columns by name
cursor = conn.cursor()
# 1. Explore schema
cursor.execute("SELECT name FROM sqlite_master WHERE type='table'")
tables = [row[0] for row in cursor.fetchall()]
# 2. Get dimensions/metadata from config table
cursor.execute("SELECT * FROM MetadataTable LIMIT 1")
metadata = dict(cursor.fetchone())
# 3. Build indexed data structure
data = {}
cursor.execute("SELECT * FROM MainTable")
for row in cursor.fetchall():
key = row["ID"] # or compute: (row["X"], row["Y"])
data[key] = dict(row)
# 4. Join related data
cursor.execute("SELECT * FROM RelatedTable")
for row in cursor.fetchall():
key = row["ID"]
if key in data:
data[key]["extra_field"] = row["Value"]
conn.close()
return {"metadata": metadata, "items": list(data.values())}Handle Missing Tables Gracefully
def safe_query(cursor, query):
try:
cursor.execute(query)
return cursor.fetchall()
except sqlite3.OperationalError:
return [] # Table doesn't existStep 4: Output as Structured JSON
Map/Dictionary Output
Use when items have natural unique keys:
{
"metadata": {"width": 44, "height": 26},
"tiles": {
"0,0": {"terrain": "GRASS", "feature": null},
"1,0": {"terrain": "PLAINS", "feature": "FOREST"},
"2,0": {"terrain": "COAST", "resource": "FISH"}
}
}Array Output
Use when order matters or keys are simple integers:
{
"metadata": {"width": 44, "height": 26},
"tiles": [
{"x": 0, "y": 0, "terrain": "GRASS"},
{"x": 1, "y": 0, "terrain": "PLAINS", "feature": "FOREST"},
{"x": 2, "y": 0, "terrain": "COAST", "resource": "FISH"}
]
}Common Schema Patterns
Grid/Map Data
- Main table: positions with base properties
- Feature tables: join on position ID for overlays
- Compute (x, y) from linear ID:
x = id % width, y = id // width
Hierarchical Data
- Parent table with primary key
- Child tables with foreign key reference
- Use LEFT JOIN to preserve all parents
Enum/Lookup Tables
- Type tables map codes to descriptions
- Join to get human-readable values
Debugging Tips
-- Sample data from any table
SELECT * FROM TableName LIMIT 5;
-- Count rows
SELECT COUNT(*) FROM TableName;
-- Find distinct values in a column
SELECT DISTINCT ColumnName FROM TableName;
-- Check for nulls
SELECT COUNT(*) FROM TableName WHERE ColumnName IS NULL;© benchflow-ai, Apache-2.0. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file
Files
Just SKILL.md in tasks/civ6-adjacency-optimizer/environment/skills/sqlite-map-parser of benchflow-ai/skillsbench.
Open the folder on GitHubat commit 9a1f4dd
Compare with similar skills
Sqlite Map Parser next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.
| Skill | Stars | Used in | Tokens | Auto-check | Licence | Repo updated |
|---|---|---|---|---|---|---|
| Sqlite Map Parser this skillbenchflow-ai/skillsbench | 1.8k | — | ~1k | Automated safety check: Pass | Apache-2.0 | |
| Sqlite Schema Designfastrepl/anarlog | 9.4k | — | ~1.9k | Automated safety check: Pass | MIT | |
| Fantasia Flatten Database Schemasvishiri/fantasia-archive | 409 | — | ~653 | Automated safety check: Pass | GPL-3.0 | |
| Add Memory KindEverMind-AI/EverOS | 13k | — | ~2.6k | Automated safety check: Pass | Apache-2.0 | |
| Cursor BYOK Database Schemaleookun/cursor-byok | 3.2k | — | ~1.3k | Automated safety check: Pass | MIT | |
| Golang Databaseunxed/f4 | 240 | 2 repos | ~2.9k | Automated safety check: Pass | MIT |
Similar skills
Fantasia Flatten Database Schemas
vishiri/fantasia-archive
Collapses .faproject SQLite PRAGMA userversion ladders into a single bootstrap schema (procedure sets max to 1) during pre-release dev resets.
Add Memory Kind
EverMind-AI/EverOS
Walks through adding a new persisted memory kind to EverOS: choose storage among Markdown, SQLite and LanceDB, pick a Markdown strategy, then wire schemas, repos and writers.
Cursor BYOK Database Schema
leookun/cursor-byok
Guides SQLite schema changes in the Cursor BYOK server, keeping SQLx migrations, the Rust store, API contracts and fixtures aligned.
Golang Database
unxed/f4
Comprehensive guide for Go database access — parameterized queries, struct scanning, NULLable columns, transactions, isolation levels, SELECT FOR UPDATE, connection pool, batch processing, context…
Database Expert
cin12211/orca-q
Database performance optimization, schema design, query analysis, and connection management across PostgreSQL, MySQL, MongoDB, and SQLite with ORM integration.
More from benchflow-ai/skillsbench
All 180 skills in this repoLean4 Memories
benchflow-ai/skillsbench
This skill should be used when working on Lean 4 formalization projects to maintain persistent memory of successful proof patterns, failed approaches, project conventions, and user preferences…
Senior Data Engineer
benchflow-ai/skillsbench
World-class data engineering skill for building scalable data pipelines, ETL/ELT systems, real-time streaming, and data infrastructure.
Ac Branch Pi Model
benchflow-ai/skillsbench
AC branch pi-model power flow equations (P/Q and |S|) with transformer tap ratio and phase shift, matching acopf-math-model.md and MATPOWER branch fields.
Civ6lib
benchflow-ai/skillsbench
Civilization 6 district mechanics library. An agent skill from benchflow-ai/skillsbench.
D3 Visualization
benchflow-ai/skillsbench
Build deterministic, verifiable data visualizations with D3.js (v6).
Dc Power Flow
benchflow-ai/skillsbench
DC power flow analysis for power systems. An agent skill from benchflow-ai/skillsbench.
Related
Works with
Categories
Questions about Sqlite Map Parser
What does Sqlite Map Parser do?
Parse SQLite databases into structured JSON data. An agent skill from benchflow-ai/skillsbench. Sqlite Map Parser is an agent skill from benchflow-ai/skillsbench. Parse SQLite databases into structured JSON data.
When should I use Sqlite Map Parser?
Sqlite Map Parser fits situations like: exploring unknown database schemas; understanding table relationships; extracting map data as JSON.
How do I install Sqlite Map Parser in Claude Code?
Run `npx skills add benchflow-ai/skillsbench --skill sqlite-map-parser -a claude-code`. Or copy the skill folder (tasks/civ6-adjacency-optimizer/environment/skills/sqlite-map-parser in benchflow-ai/skillsbench) into .claude/skills/sqlite-map-parser in your project. Claude Code loads it when a task matches its description.
How do I install Sqlite Map Parser in Codex?
Run `npx skills add benchflow-ai/skillsbench --skill sqlite-map-parser -a codex`. Or copy the skill folder (tasks/civ6-adjacency-optimizer/environment/skills/sqlite-map-parser in benchflow-ai/skillsbench) into .agents/skills/sqlite-map-parser in your project. Codex loads it when a task matches its description.
Can I use Sqlite Map Parser in Cursor, Gemini CLI or GitHub Copilot?
Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add benchflow-ai/skillsbench --skill sqlite-map-parser -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/sqlite-map-parser, .gemini/skills/sqlite-map-parser, .github/skills/sqlite-map-parser and .opencode/skills/sqlite-map-parser in your project.
What does Sqlite Map Parser need to run?
SKILL.md names no scripts, command-line tools or credentials: Sqlite Map Parser is instructions for the agent only. Our summary lists: Python 3.
Does Sqlite Map Parser access the network?
SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.
Is Sqlite Map Parser safe to install?
Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.
What licence does Sqlite Map Parser use?
Sqlite Map Parser is published under the Apache-2.0 licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.
How many tokens does Sqlite Map Parser use?
About 1k tokens (SKILL.md is roughly 4.2k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.
What are the alternatives to Sqlite Map Parser?
Skills that share tags, products or a category with Sqlite Map Parser: Sqlite Schema Design (fastrepl/anarlog, 9.4k stars), Fantasia Flatten Database Schemas (vishiri/fantasia-archive, 409 stars), Add Memory Kind (EverMind-AI/EverOS, 13k stars) and Cursor BYOK Database Schema (leookun/cursor-byok, 3.2k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.
Who maintains Sqlite Map Parser?
benchflow-ai (a GitHub organization) maintains it in benchflow-ai/skillsbench, which has 1,832 GitHub stars. The repository holds 180 skills in this directory. The repository was last updated on July 23, 2026.
Source: benchflow-ai/skillsbench on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.