- Home
- Skills
- Data & Databases
- ExNihilo 95 — Zero-Config SQL IDE & Relational Reasoning Eng
More screenshots
Works with the AI Agents you already use
ExNihilo 95 — Zero-Config SQL IDE & Relational Reasoning Eng
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
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 ANALYZEon 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:
- 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).
- 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.
- 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).
- Guided solutions for classic and tricky interview problems (window ranking, dense rank, offset
- 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).
- Diagnoses SARGability anti-patterns (e.g.
📦 Includes:
SKILL.mdagent 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.
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
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
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before any payment.
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 forever
No account required to browse
Trust & safety
Security scan
Security scan passed 7 days ago
- Free with an Agensi account
Requires
Permissions
Runs local SQL analysis and dialect transpilation. Does not make external network calls or touch credentials.