database

What problem does it solve?

This Skill simplifies complex database setup and management tasks, from creating new PostgreSQL databases to generating Prisma schemas and handling migrations. It ensures consistent, error-free database operations, freeing developers from manual configuration and potential errors.

Core Features & Use Cases

• Automated PostgreSQL Provisioning: Creates dedicated databases on a shared VPS with strict naming conventions, ensuring project isolation.
• Prisma ORM Integration: Generates schema.prisma based on project features, manages migrations (db push or migrate dev), and sets up the Prisma Client singleton for efficient data access.
• Data Seeding & Management: Seeds test data for rapid development and provides tools for backup, restore, and direct access via Prisma Studio.
• Use Case: When starting a new project, simply ask the AI "Set up a PostgreSQL database for my new task management app with Prisma" and it will provision the database, configure Prisma, and even seed initial data.

Quick Start

Create a new PostgreSQL database named 'my_new_project_db' and set up a basic Prisma schema for a 'User' model.