tecton-cli

TectonCLI

JSON Schema → SQLite — with AI-powered data extraction

Define your data structure once. Generate a database. Extract documents into it.

npm install -g tecton-cli

cd my-project && tecton-cli schema --init   # set up your schema directory
tecton-cli schema "*.json"                   # generate SQLite from JSON Schema
tecton-cli extract -s invoice -f invoice.pdf # extract data with AI

✨ Features

• JSON Schema → SQLite — Define tables as JSON Schema files, generate Drizzle ORM schema, and migrate to SQLite
• Visual Editor — Browser-based UI for designing schemas without writing JSON by hand
• AI Extraction — Extract structured data from text, images, and PDFs using any OpenAI-compatible provider (OpenAI, Anthropic, Ollama, DeepSeek, local models, etc.)
• Built-in Model Registry — Knows capabilities of 2000+ models (vision, structured output) so you don't have to guess

🚀 Getting Started

1. Initialize

tecton-cli schema --init

Creates a .tecton/ directory with example schemas to get you started.

2. Visual Editor

tecton-cli web

Opens a browser UI where you can visually design and manage your schemas, configure AI settings, preview extraction prompts, and apply changes to the database.

3. Generate Database

tecton-cli schema "*.json"

Converts your JSON Schema files into a SQLite database with full migration support.

4. Extract Data

tecton-cli extract -s <schema> -f <file>  # from file (txt, pdf, png, jpg, ...)
tecton-cli extract -s <schema> -t <text>  # from text

The AI reads your document and outputs structured JSON matching your schema.

Example:

tecton-cli extract -s paper -f research.pdf

Creates output.json with fields like title, firstAuthor, journal, year — exactly as defined in your schema.

📖 Commands

Command	Description
tecton-cli schema --init	Scaffold .tecton/ directory with example schemas
tecton-cli schema <files>	Parse JSON Schema files and migrate to SQLite
tecton-cli schema --generate	Generate Drizzle schema code only (skip migration)
tecton-cli web	Launch visual schema editor in browser
tecton-cli extract -s <name>	Extract structured data from documents via AI
tecton-cli doctor	System and configuration diagnostics

🔧 AI Configuration

tecton works with any OpenAI-compatible API provider. Configure in the Web UI (AI Settings panel):

• Provider — Set your base URL and API key
• Models — Add models with vision and/or structured output capabilities
• Prompts — Customize system and user prompt templates with {schema} and {text} placeholders

The built-in model registry automatically suggests capabilities for 2000+ models from providers including OpenAI, Anthropic, Google, Meta, Mistral, DeepSeek, Alibaba Cloud, and more.

🙏 Acknowledgments

This project includes source code adapted from jsonschema-builder-vue by Gabriel Casotti, used and modified under the MIT License.

The AI model capabilities registry is derived from LiteLLM's model_prices_and_context_window.json, used under the MIT License.

📄 License

MIT © OSpoon