skills.rest
ehtbanton
ehtbantonCOMMUNITY
Explore all skills by this author →
GitHub

sql-schema-generator

Generate SQL schema files for PostgreSQL, MySQL, and SQLite.

Updated Dec 17, 2025
Search Tags:#database#postgresql#schema#sqlite#sql#generation#mysql
One-click install
npx skills add https://github.com/ehtbanton/ClaudeSkillsRepo --skill sql-schema-generator-ehtbanton
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sql-schema-generator
Source: https://github.com/ehtbanton/ClaudeSkillsRepo/tree/main/sql-schema-generator
Command: npx skills add https://github.com/ehtbanton/ClaudeSkillsRepo --skill sql-schema-generator-ehtbanton

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill automates the creation of SQL database schema files, saving developers significant time and ensuring consistency in database design.

Core Features & Use Cases

  • Schema Generation: Creates complete, normalized SQL schemas for PostgreSQL, MySQL, or SQLite.
  • Table, Relationship, Index, Constraint Definition: Generates all necessary database objects.
  • Use Case: Generate a PostgreSQL schema for a new e-commerce platform, including tables for users, products, orders, and reviews, complete with relationships and indexes.

Quick Start

Generate a PostgreSQL schema for a blog with posts, comments, and tags.

Frequently Asked Questions about sql-schema-generator

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I generate a SQL database schema for PostgreSQL, MySQL, or SQLite?▼

You can generate a SQL database schema by specifying your application requirements, and this Skill outputs complete, normalized schema files for PostgreSQL, MySQL, or SQLite, including tables, relationships, indexes, and constraints.

What is the best way to create tables and relationships for an e-commerce database?▼

To create e-commerce database tables and relationships, this Skill applies common database design patterns and best practices, generating normalized schemas that include users, products, orders, and reviews with appropriate constraints.

Can I use this to generate a schema for a SaaS application?▼

Yes, you can generate a schema for a SaaS application. The Skill supports various application types, including SaaS, and applies common database design patterns to produce normalized SQL schemas with tables, relationships, and constraints.

Does the generated schema include indexes and constraints?▼

Yes, the generated SQL schema includes indexes and constraints. The Skill defines all necessary database objects, producing complete schema files with tables, relationships, indexes, and constraints for PostgreSQL, MySQL, and SQLite.

How do I create a normalized SQL schema for a blog with posts, comments, and tags?▼

You can create a normalized SQL schema for a blog by requesting tables for posts, comments, and tags. The Skill automates the process, generating complete schema files with proper relationships and constraints for your chosen database system.

Related Skills

Explore More Software Engineering Skills→
omraval18omraval18

schema-markup-generator

Generate JSON-LD structured data markup for Article, Product, and LocalBusiness schema types.

Community
Intermediate
inbharataiinbharatai
22

db-schema-designer

Design normalized relational database schemas with ERDs, indexes, constraints, and migration scripts.

Community
Intermediate
mmsu-pawpatrolmmsu-pawpatrol
2

prisma-cli

Reference Prisma CLI commands for migrations, schema validation, and database management.

Official
Intermediate
jie023jie023
36

database-design-template

Generate standardized database design templates and SQL scripts.

Community
Basic