Sqlite Map Parser
Parse SQLite databases into structured JSON data. Use when exploring unknown database schemas, understanding table relationships, and extracting map data as JSON.
Install
npx skills add UCSB-NLP-Chang/Skill-Usage --skill sqlite-map-parsergit clone --depth 1 https://github.com/UCSB-NLP-Chang/Skill-Usage.git /tmp/Skill-Usage
mkdir -p ~/.claude/skills
cp -r /tmp/Skill-Usage/tasks/civ6-adjacency-optimizer/environment/skills/sqlite-map-parser ~/.claude/skills/sqlite-map-parserPersonal skills live in ~/.claude/skills. Use .claude/skills in a project folder to share a skill with your team.
From the SKILL.md
# 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 ```sql SELECT name FROM sqlite_master WHERE type='table'; ``` ### Inspect Table Schema ```sql -- Get column names and types PRAGMA table_info(TableName); -- See CREATE statement SELECT sql FROM sqlite_master WHERE name='TableName'; ``` ### Find Primary/Unique Keys ```sql -- 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 ```sql PRAGMA foreign_key_list(TableName); ``` ### Common Patterns **ID-based joins:** Tables often share an ID column ```sql -- 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 ```python # If ID represents a linear index into a grid: x = id % width y = id // width ``` ## Step 3: Extract and Transform ### Basic Pattern
Details
- Skill name
sqlite-map-parser- Repository
- UCSB-NLP-Chang/Skill-Usage
- Path
tasks/civ6-adjacency-optimizer/environment/skills/sqlite-map-parser/SKILL.md- Repo updated
- 8 April 2026
FAQ
What does the Sqlite Map Parser skill do?
Parse SQLite databases into structured JSON data. Use when exploring unknown database schemas, understanding table relationships, and extracting map data as JSON.
How do I install the Sqlite Map Parser skill?
skills CLI (Claude Code, Cursor, Codex and more): npx skills add UCSB-NLP-Chang/Skill-Usage --skill sqlite-map-parser. Skills go in ~/.claude/skills (personal) or .claude/skills (project), and Claude loads them automatically when a task matches the description.
Is Sqlite Map Parser popular?
It lives in UCSB-NLP-Chang/Skill-Usage, which has 49 GitHub stars and 5 forks.
Related skills
Pubchem Database
49UCSB-NLP-Chang/Skill-Usage
Query PubChem via PUG-REST API/PubChemPy (110M+ compounds). Search by name/CID/SMILES, retrieve properties, similarity/substructure searches, bioactivity, for cheminformatics.
Pymatgen
49UCSB-NLP-Chang/Skill-Usage
Materials science toolkit. Crystal structures (CIF, POSCAR), phase diagrams, band structure, DOS, Materials Project integration, format conversion, for computational materials science.
Rdkit
49UCSB-NLP-Chang/Skill-Usage
Cheminformatics toolkit for fine-grained molecular control. SMILES/SDF parsing, descriptors (MW, LogP, TPSA), fingerprints, substructure search, 2D/3D generation, similarity, reactions. For standard workflows with simpler interface, use datamol (wrapper around RDKit). Use rdkit for advanced control, custom sanitization, specialized algorithms.
Caching Strategy
48sethdford/claude-skills
Design multi-layer caching strategies (client, edge, service, database) for performance. Use when optimizing latency or reducing database load.
Zinc Database
43lifangda/claude-plugins
Access ZINC (230M+ purchasable compounds). Search by ZINC ID/SMILES, similarity searches, 3D-ready structures for docking, analog discovery, for virtual screening and drug discovery.
Data Partitioning
48sethdford/claude-skills
Design partitioning and sharding strategies for data at scale. Use when single database hits throughput or storage limits.
Browse the most popular Claude skills, all databases skills, or write your own with the skills generator.