More screenshots

    Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIDeepSeekDeepSeekMuseMuse+22 more

    ExNihilo 95 — Zero-Config SQL IDE & Relational Reasoning Eng

    1

    Auto-infers schemas and generates referentially sound synthetic datasets from bare queries, solves 130+ LeetCode SQL challenges, transpiles between PostgreSQL, MySQL, SQLite & T-SQL, and optimizes query execution plans.

    Free

    Security scanned

    ExNihilo 95 — Zero-Config SQL IDE & Relational Reasoning Eng

    Example session with this skill installed

    I have this query but no schema: SELECT u.name, o.total FROM users u JOIN orders o ON u.id = o.user_id WHERE o.created_at > '2024-01-01'. Generate the DDL and mock data for PostgreSQL.

    • Read your context and instructions
    • Compiled the exnihilo 95

    I have analyzed the query and inferred the relational structure. The schema accounts for the join condition between users and orders, identifying user_id as a foreign key. I've also applied type heuristics to ensure created_at is a timestamp and total is numeric.

    Inferred Schema and Synthetic Data (PostgreSQL)

    -- 1. Create Tables in topological order
    CREATE TABLE users (
        id SERIAL PRIMARY KEY,
        name VARCHAR(255) NOT NULL
    );
    
    CREATE TABLE orders (
        id SERIAL PRIMARY KEY,
        user_id INTEGER REFERENCES users(id),
        total NUMERIC(10,2),
        created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
    );
    
    -- 2. Insert referentially sound mock data
    INSERT INTO users (name) VALUES 
    ('Alice Chen'), ('Bob Smith'), ('Charlie Davis'), ('Diana Prince');
    
    INSERT INTO orders (user_id, total, created_at) VALUES 
    (1, 150.50, '2024-02-15 10:30:00'),
    (1, 42.00, '2024-03-01 12:00:00'),
    (2, 99.99, '2024-01-20 09:15:00'),
    (3, 250.00, '2024-04-10 16:45:00'),
    (4, 12.50, '2024-05-05 11:00:00');
    

    Next steps

    • Execute the script in your local PostgreSQL instance to test the query performance.
    • Use EXPLAIN ANALYZE on the generated data to check for sequential scans.
    • Request additional rows if you need to test pagination or large-scale aggregations.

    Connects securely to your tools. The creator never sees your data.

    About this skill

    The Intelligent SQL Skill That Eliminates "Table Not Found" Errors

    When developers, students, or data analysts ask AI coding agents to write, debug, or test SQL queries without providing table definitions or schemas, standard agents stall or fail. ExNihilo 95 brings the "Creatio Ex Nihilo" (creation out of nothing) engine to Claude Code, Cursor, Copilot, Antigravity, and 20+ AI agents.

    ⚡ What Your AI Agent Can Do With This Skill:

    1. Schema & Synthetic Mock Data Inference:
      • Auto-infers tables, columns, data types, and primary/foreign keys directly from query ASTs.
      • Synthesizes realistic mock datasets with strict referential integrity (100% matches on INNER JOINs, realistic orphan ratios on LEFT JOINs).
    2. Multi-Dialect Transpiler & Parity Matrix:
      • Translates queries across PostgreSQL 16+, MySQL 8.0+, SQLite 3.45+, and Microsoft SQL Server (T-SQL).
      • Covers date math (DATE_ADD, DATEADD, INTERVAL), string aggregations (STRING_AGG, GROUP_CONCAT), pattern matching (ILIKE, REGEXP), and full outer join emulations.
    3. 130+ LeetCode SQL Challenge Arena Coach:
      • Guided solutions for classic and tricky interview problems (window ranking, dense rank, offset LAG/LEAD, consecutive day detection, recursive org hierarchies).
    4. Query Performance & Indexing Optimizer:
      • Diagnoses SARGability anti-patterns (e.g. WHERE YEAR(date) = 2025).
      • Recommends optimal B-tree composite index column order (Equality before Sort before Range) and covering indexes (INCLUDE).

    📦 Includes:

    • SKILL.md agent specification
    • Reference guides for dialect syntax, schema inference, 130+ challenges, and query optimization
    • Standalone pure-Python CLI transpiler and mock generator (scripts/sql_dialect_transpiler.py) with zero third-party dependencies.

    Find more skills like this on the Claude Skills Marketplace, the Codex Skills Marketplace and the Gemini Skills Marketplace, or browse Claude Skills for Data & Databases.

    Default generation is capped at 20 rows per table. Specialized vendor-specific JSON operators or proprietary extensions might require manual fine-tuning after transpilation.

    How to use

    1. 1

      Connect your agent to the Agensi MCP

      Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup

    2. 2

      Sign in to Agensi

      Your agent shows a sign-in link. Sign in and click Allow.

    3. 3

      Ask for what you need

      Your agent loads this skill and uses it on your task. It always asks before buying a skill.

    Reviews

    No reviews yet

    Be one of the first to try it. Every listed skill goes through the trust checks below.

    Security scanned

    Checked by our 8-point scan before listing

    Fresh listing

    Recently published to Agensi

    Free to use

    No account required to browse

    Trust & safety

    Security scan

    Security scan passed 7 days ago

    • Free with an Agensi account

    Software
    Python

    Pure Python 3 standard library only. Zero external pip dependencies required.

    Permissions

    Terminal / Shell
    Read Files

    Runs local SQL analysis and dialect transpilation. Does not make external network calls or touch credentials.

    Listed7 days ago

    What's inside

    Frequently Asked Questions

    exnihilo 95 analyzes your raw SQL queries to reverse-engineer table structures, relationships, and data types, then generates a complete DDL script and referentially consistent mock data so you can test code without a live database.

    The skill is universally compatible with agentic IDEs like Cursor, Claude Code, and GitHub Copilot, and it also includes a standalone Python CLI for offline schema generation and dialect translation.

    Unlike generic prompts, this skill uses a deterministic inference pipeline and a built-in parity matrix to ensure that foreign key relationships remain intact across mock datasets and that dialect-specific functions are translated accurately.

    Yes, it supports bi-directional transpilation between PostgreSQL, MySQL, SQLite, and T-SQL, handling the heavy lifting of converting syntax for date functions, pagination, and aggregation.

    You receive the core inference engine for use within your AI agent, the standalone Python CLI tool, and a library of idiomatic solutions for over 130 advanced SQL challenges.

    By default, the engine generates 10–20 rows of referentially sound data per table, which is optimized for rapid unit testing and debugging rather than large-scale performance benchmarking.

    New in Data & Databases

    Free