skills.rest
spaethtech
spaethtechCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

database

Generate database schemas and migrations for PostgreSQL, MySQL, or SQLite with Drizzle or Prisma.

Updated Jan 30, 2026
Search Tags:#database#drizzle#migrations#orm#psql#prisma#schema-generation
One-click install
npx skills add https://github.com/spaethtech/sveltekit-auth --skill database-spaethtech
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database
Source: https://github.com/spaethtech/sveltekit-auth/tree/main/.claude/skills/database
Command: npx skills add https://github.com/spaethtech/sveltekit-auth --skill database-spaethtech

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Managing database schemas, migrations, and adapters across multiple databases is error-prone and repetitive. This skill provides a CLI-driven approach to generate and organize database schemas inside your project, supports multiple databases (PostgreSQL, MySQL, SQLite), and keeps library-managed entities separate from user code.

Core Features & Use Cases

  • CLI-driven schema generation: Generate and place schema files into the project with a single command.
  • Adapters & repository pattern: Implement the repository interface to abstract database operations (users, accounts, sessions, verifications).
  • Multi-database & multi-ORM support: Works with PostgreSQL (default), MySQL, SQLite; supports Drizzle (default) and Prisma.
  • Generated files & tables: Provides a structured schema under src/lib/server/schemas with tables like users, accounts, sessions, verifications and documented relationships.

Quick Start

Run the CLI to generate schema files in your project with default PostgreSQL + Drizzle settings.

Frequently Asked Questions about database

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

FAQPage Schema
How do I automate database schema generation and migrations for PostgreSQL?▼

You can automate database schema generation by running a CLI command that creates and places schema files into your project. It defaults to PostgreSQL with Drizzle, generating structured tables for users, accounts, sessions, and verifications.

Can I use Prisma instead of Drizzle for database migrations?▼

Yes, you can use Prisma instead of Drizzle for database migrations. The CLI supports multi-ORM integration, allowing you to generate schemas and manage repository adapters using either Drizzle or Prisma across PostgreSQL, MySQL, or SQLite.

Does this database schema generation tool support MySQL and SQLite?▼

Yes, the database schema generation tool supports MySQL and SQLite in addition to PostgreSQL. It allows you to configure the target database when running the CLI to generate schemas and implement the repository interface.

What is the repository pattern for database adapters in this workflow?▼

The repository pattern abstracts database operations by implementing an Adapter interface. This interface defines methods for managing users, accounts, sessions, and verifications, keeping library-managed entities separate from user code.

Where are generated database schema files placed in the project structure?▼

Generated database schema files are placed under src/lib/server/schemas. This structured placement ensures library-managed entities and adapter files remain separate from your user code.

Why use a CLI for database schema management instead of manual migrations?▼

Using a CLI for database schema management prevents the error-prone and repetitive nature of manual migrations. It automates schema creation, migration generation, and adapter integration across multiple databases to ensure consistency.

Related Skills

Explore More Software Engineering Skills→
MakisuoMakisuo
1.6k

clickhousectl-local-dev

Install and configure a local ClickHouse environment with clickhousectl.

Community
Intermediate
shahdanishshahdanish

migration-workflow

Execute EF Core schema migrations with SQL review, rollback, and verification.

Community
Advanced
pluginagentmarketplacepluginagentmarketplace
3

api-routes

Implement Next.js API route handlers and middleware for app/api endpoints.

Community
Intermediate
linenoizelinenoize
1

db

Generate rollback-aware database migration files and validate schema changes.

Community
Advanced