Zero-CRUD VS Code Extension From SQL to full-stack
Paste your database schema, configure fields and permissions visually, and generate a complete full-stack app.
Databases: MySQL / PostgreSQL / SQLite / MariaDB Backends: TypeScript / Python / Go / Java Frontends: Vue / React Permissions, data ownership, and complex queries built in. Work with AI — on a rock-solid foundation.
Zero-CRUD
is a visual API builder and full-stack code generator. 1. Create a project, pick a DB dialect and frontend/backend templates 2. Submit your database schema (DDL) 3. Configure field visibility, permissions, system fields and more visually 4. Generate frontend & backend code, README, Docker scripts and more in one click 5. Run and debug locally to see the result 6. Build your own business logic on top
Built for real production apps
Not just generated code — permissions, ownership, and security designed in from the start.
Multi-Platform
One schema, many targets: SQLite, MySQL, PostgreSQL, MariaDB. TypeScript, Python, Go, or Java backends plus Vue or React frontends.
Complex Queries
Filters, comparison operators, ranges, and nested conditions — build powerful list queries without writing SQL or code.
Pagination Built In
Offset pagination with total counts on every list endpoint, ready for large tables from day one.
System Fields
created_at, updated_at, version, and created_by handled automatically — timestamps, optimistic locking, and audit trails wired into every table.
Fine-grained Permissions
Action-level and field-level permission rules per project. Decide who can create, read, update, or delete — down to individual fields.
Data Ownership
Generated code ships with ownership checks and per-user data isolation built in.
Foreign Keys, Visible
Foreign-key relationships surfaced clearly in the table editor and reflected in the generated API and schema.
Security by Design
Parameterized, injection-safe queries, rate limiting, resource limits, and auth-ready output — secure by default, not an afterthought.
Run & Debug Instantly
Start the generated project in one click — database, dependencies and ports handled automatically. Debug APIs right in the workbench and export Postman collections & OpenAPI specs.
Work with AI — build on a rock-solid foundation.
AI makes "writing code" easier than ever, but taking code from "it runs" to stable, clean, and maintainable requires determinism. Zero-CRUD starts from a standardized table schema and produces a consistent, reliable full-stack foundation every time — then your AI tools add their personalized logic on top.
Start with SQL. Ship full-stack.
Paste your DDL, pick your stack, and generate everything in one click.
-- 1. DDL input
CREATE TABLE products (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT NOT NULL,
price REAL NOT NULL DEFAULT 0.0,
is_active INTEGER NOT NULL DEFAULT 1 CHECK(is_active IN (0,1)),
created_at DATETIME NOT NULL DEFAULT (datetime('now'))
);
-- 2. Pick languages
Backend: TypeScript / Python / Go / Java
Frontend: Vue 3 / React
-- 3. Generate → Run
npm run dev # Backend on :3000
npm run dev # Frontend on :5173Ready to build?
Install the VS Code extension, open a SQL file, and get a complete full-stack system in under a minute.