How does it handle performance optimization?

The skill suggests proper indexing strategies, connection pooling configurations, and the use of EXPLAIN ANALYZE for identifying and fixing slow queries.

What database technologies does this skill support?

This skill is specifically designed for Drizzle ORM and Neon PostgreSQL, providing optimized patterns for type-safe queries and serverless database management.

Can this skill help with database migrations?

Yes, it includes specialized knowledge for generating and applying migrations using Drizzle's CLI tools like db:generate and db:migrate.

Where should I organize my database logic?

It recommends placing schema definitions in the drizzle/ directory and queries within src/server/queries/ to maintain a clean and scalable project structure.

Database Management & Drizzle ORM

Name: Database Management & Drizzle ORM
Author: artiefy

byartiefy

•

Database Management

Manages database operations, schema definitions, and migrations using Drizzle ORM and Neon PostgreSQL for robust data layers.

About

The Database Management skill provides specialized expertise for developers working with the Artiefy stack, focusing on Drizzle ORM and Neon PostgreSQL. It streamlines the creation of type-safe schemas, the execution of complex relational queries, and the management of version-controlled migrations. By implementing best practices for performance optimization, connection pooling, and transaction handling, this skill ensures that database interactions are efficient, scalable, and maintainable throughout the application lifecycle.

Key Features

2 GitHub stars
Optimized query patterns and transaction management
Type-safe schema definition with Drizzle ORM
Integration with Neon serverless PostgreSQL infrastructure
Visual schema management support via Drizzle Studio
Automated migration generation and execution workflows

Use Cases

Writing and optimizing high-performance SQL queries and transactions
Designing complex relational database models and constraints
Managing version-controlled schema evolutions and migrations

About

Key Features

2 GitHub stars
Optimized query patterns and transaction management
Type-safe schema definition with Drizzle ORM
Integration with Neon serverless PostgreSQL infrastructure
Visual schema management support via Drizzle Studio
Automated migration generation and execution workflows

Use Cases

Writing and optimizing high-performance SQL queries and transactions
Designing complex relational database models and constraints
Managing version-controlled schema evolutions and migrations