skills.rest
GeneralReasoning
GeneralReasoningOFFICIAL
Explore all skills by this author →
Website𝕏@GenReasoningGitHub

sqlite-map-parser

Parse SQLite databases into structured JSON data.

4|Updated Feb 22, 2026
Search Tags:#database#schema#analysis#json#sqlite
One-click install
npx skills add https://github.com/GeneralReasoning/env-skillsbench --skill sqlite-map-parser-generalreasoning
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sqlite-map-parser
Source: https://github.com/GeneralReasoning/env-skillsbench/tree/main/civ6-adjacency-optimizer/environment/skills/sqlite-map-parser
Command: npx skills add https://github.com/GeneralReasoning/env-skillsbench --skill sqlite-map-parser-generalreasoning

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Parse SQLite databases into structured JSON data for easier analysis and data exchange by first exploring schemas and then extracting data into a consistent JSON structure.

Core Features & Use Cases

  • Schema discovery: list tables, inspect columns, identify primary and foreign keys to understand the data model.
  • Data extraction: convert selected table rows into structured JSON for downstream processing.
  • Use Case: when encountering an unknown database, rapidly map structure and export data for validation and integration.

Quick Start

Run the parser against a SQLite database file to produce a JSON object containing metadata and items.

Frequently Asked Questions about sqlite-map-parser

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I export a SQLite database schema and data to JSON?▼

To export a SQLite database to JSON, you need a parser that reads sqlite_master and PRAGMA statements. This Skill extracts table structures, primary and foreign keys, and row data into a structured JSON format for analysis.

What is the best way to map unknown table relationships in SQLite?▼

Mapping unknown SQLite table relationships requires schema discovery to identify primary and foreign keys. This parser inspects columns and table dependencies, outputting a structured JSON map of the data model.

Can I extract SQLite table rows into structured JSON without writing Python code?▼

Yes, you can extract SQLite table rows into structured JSON without manual Python coding. The parser handles reading the database file and joining related data into a consistent JSON structure automatically.

Does the SQLite to JSON parser work with databases that have complex nested foreign keys?▼

The SQLite to JSON parser handles databases with foreign keys by reading PRAGMA statements. It joins related data effectively, though extremely complex nested relationships may require reviewing the output structure.

When do I need to convert a SQLite database into a JSON file?▼

You need to convert a SQLite database into JSON when encountering an unknown database for validation, data exchange, or integration. It allows you to rapidly map structure and export data for downstream processing.

Related Skills

Explore More Data & Analytics Skills→
Archive228Archive228
746

schema-diff

Compare two schema states to identify risky changes before database migrations.

Community
Intermediate
expanso-ioexpanso-io

expanso-enforce-schema

Validate incoming JSON data against a JSON schema and route invalid records to a dead-letter queue.

Official
Advanced
lukegob10lukegob10

schema-exploration

Automate schema discovery and relationship mapping in relational databases.

Community
Intermediate
HmbownHmbown
50

schema_exploration

List database tables and detail columns, data types, and relationships.

Community
Intermediate