database

Provisions PostgreSQL databases on a VPS and generates Prisma schemas with migrations.

Updated Aug 23, 2026
One-click install
npx skills add https://github.com/nera0875/BUILDER --skill database
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: database
Source: https://github.com/nera0875/BUILDER/tree/main/.claude/skills/database
Command: npx skills add https://github.com/nera0875/BUILDER --skill database

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires prisma, @prisma/client, tsx, bcryptjs, psycopg2-binary.

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.

Frequently Asked Questions about database

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

FAQPage Schema
How do I set up a PostgreSQL database with Prisma for a new project?

PostgreSQL database setup with Prisma involves provisioning a dedicated database on your VPS, generating a schema.prisma file based on your models, and configuring the DATABASE_URL environment variable. This Skill automates the entire process—database creation, Prisma schema generation, and migrations—so you can start developing immediately without manual configuration.

Can I use Prisma migrations to manage my PostgreSQL schema changes?

Yes. Prisma migrations manage PostgreSQL schema changes through db push or migrate dev commands. This Skill generates your initial schema.prisma, handles migration execution, and ensures changes are applied consistently across your project database.

What's the best way to seed test data into PostgreSQL during development?

Data seeding populates your PostgreSQL database with test data for rapid development cycles. This Skill provides automated seeding tools that inject initial data after schema setup, so your development environment is ready to test immediately without manual INSERT statements.

How do I back up and restore a PostgreSQL database for a Prisma project?

Backup and restore operations preserve your PostgreSQL data and schema. This Skill includes backup and restore tooling integrated with your Prisma setup, enabling you to safely capture database state and recover from issues without downtime.

Does this work with multiple projects sharing a single PostgreSQL VPS?

Yes. This Skill enforces strict project isolation by creating dedicated databases with naming conventions on a shared VPS, assigns the pentester user for access control, and uses port 5433. Each project maintains its own isolated database while sharing infrastructure efficiently.

Why use a Skill for PostgreSQL setup instead of manual configuration?

Manual database provisioning is error-prone and time-consuming. This Skill eliminates setup inconsistencies, enforces naming conventions, configures Prisma automatically, and handles migrations and seeding—freeing you to focus on application logic instead of database administration.