What database driver does this skill implement?

It uses the high-performance postgres-js driver via the 'postgres' package, which is recommended for modern TypeScript environments and serverless compatibility.

Can I use this with Next.js App Router?

Yes, the skill is specifically designed for Next.js projects using the src/ directory and App Router, following standard path conventions like @/lib/db.

Does this skill support vector searches?

Yes, the Docker setup uses the pgvector image by default, making it fully compatible with AI-driven similarity search and vector embeddings.

How does this handle database migrations?

The skill sets up a dual workflow: 'db:push' for rapid prototyping in development and a formal 'db:generate' and 'db:migrate' flow for tracked, production-safe SQL migrations.

Does it include a visual database browser?

Yes, it configures Drizzle Studio, which you can launch via 'bun run db:studio' to view and edit your data in a web-based GUI.

PostgreSQL & Drizzle ORM Setup

Name: PostgreSQL & Drizzle ORM Setup
Author: mattwoodco

bymattwoodco

•

Database Management

Configures a type-safe PostgreSQL database layer with Drizzle ORM, Docker-based local development, and production-ready migration workflows.

The Database skill streamlines the implementation of a robust data layer for Next.js applications by automating the setup of PostgreSQL and Drizzle ORM. It provides a complete scaffolding including Docker Compose configuration for local development (featuring pgvector support), environment variable integration, and a standardized directory structure for schemas and migrations. By enforcing type-safe query patterns and providing a clear migration path, this skill ensures developers can scale from a local environment to production with confidence and minimal manual configuration.