- Home
- Skills
- Data & Databases
- db-schema
db Schema
Turn plain English app descriptions into fully normalized SQL schemas and entity relationship documentation.
$12
Works with the AI Agents you already use
db-schema
Example session with this skill installed
Design a Postgres schema for an e-commerce catalog with products including slugs and categories. Ensure categories are linked and soft deletes are enabled.
- Read your context and instructions
- Compiled the db-schema
-- schema.sql generated for Postgres
CREATE TABLE products (
id BIGSERIAL PRIMARY KEY,
slug VARCHAR(255) UNIQUE NOT NULL,
price NUMERIC(10,2) NOT NULL,
category_id BIGINT REFERENCES categories(id),
deleted_at TIMESTAMP WITH TIME ZONE
);
CREATE INDEX idx_products_category ON products(category_id);
Connects securely to your tools. The creator never sees your data.
About this skill
What it does
This skill transforms natural language requests into production-ready database architectures. It interprets high-level business requirements and automatically generates both the SQL DDL and comprehensive markdown documentation for your data layer.
Problem it solves
Designing a normalized database from scratch is time-consuming and prone to manual errors, such as missing indexes on foreign keys, inconsistent naming conventions, or improper data types for currency. This skill automates the drudgery of schema design while enforcing industry best practices from the start.
Supported Tools
- PostgreSQL: Default support with JSONB, BIGSERIAL, and automated updated_at triggers.
- MySQL: Optimized with UNSIGNED types and AUTO_INCREMENT syntax.
- SQLite: Lightweight syntax with CHECK constraints for enums.
Why use this skill
Unlike generic AI prompts, this skill applies strict 3rd Normal Form (3NF) logic, ensures every table includes audit timestamps and soft-delete support, and handles complex many-to-many junction tables automatically. It doesn't just give you code; it produces a professional SCHEMA.md directory of your entities and relationships for your team.
How to use
Skills on Agensi run inside your AI agent. Copy the prompt, paste it into your agent, and it connects to Agensi and installs this skill for you. If a payment is needed, your agent shows it to you first.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill passes our trust checks below.
Security scanned
Passed our 8-point scan before listing
Fresh listing
Recently published to Agensi
Money-back guarantee
Doesn't do what its page promises? You get your money back.
Trust & safety
Security scanned
Verified clean 6 months ago
- Passed all security checks, Safe to install