Database Architect

Name: Database Architect
Availability: InStock
Author: darblex

Design, optimize, and plan migrations for database schemas and queries.

Updated Mar 10, 2026

Search Tags:#query optimization #schema design #database #postgresql #migration #drizzle orm #prisma

Ready to run

npx skills add https://github.com/darblex/price-compare-israel --skill database-architect-darblex

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: Database Architect
Source: https://github.com/darblex/price-compare-israel/tree/main/workspace/skills/database-architect
Command: npx skills add https://github.com/darblex/price-compare-israel --skill database-architect-darblex

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill addresses the complexities of designing, optimizing, and migrating database schemas and queries for scalable applications.

Core Features & Use Cases

Schema Design: Provides examples for multi-tenant SaaS, e-commerce, and CRM systems.
Query Optimization: Offers patterns for pagination, full-text search, aggregations, and JSONB queries.
Migration Strategies: Demonstrates patterns using Prisma and Drizzle ORM.
Use Case: Design a robust, multi-tenant schema for a new SaaS product, including user and tenant tables with row-level security.

Quick Start

Generate a PostgreSQL schema for a multi-tenant SaaS application.

Frequently Asked Questions about Database Architect

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

FAQPage Schema

How do I design a multi-tenant PostgreSQL schema for a SaaS application?▼

Designing a multi-tenant PostgreSQL schema involves creating user and tenant tables with row-level security. This approach isolates tenant data while providing patterns for efficient data handling using SQL, Prisma, and Drizzle ORM.

What's the best way to optimize database queries for pagination and full-text search?▼

Optimize database queries for pagination and full-text search by applying targeted patterns for indexing, partitioning, and caching. This Skill provides specific query optimization techniques for aggregations and JSONB queries to ensure efficient data retrieval.

Can I use Drizzle ORM or Prisma for database migration strategies?▼

Yes, you can use Drizzle ORM or Prisma for database migration strategies. This Skill demonstrates specific migration patterns using both frameworks to help you plan and execute schema changes across various application types.

How do I handle schema design for e-commerce and CRM systems?▼

Handle schema design for e-commerce and CRM systems by applying tailored data layer patterns. This Skill provides examples for designing, optimizing, and migrating database schemas to ensure scalable data architectures across these application types.

When do I need to use partitioning and indexing in my database schema?▼

You need to use partitioning and indexing in your database schema when optimizing large data sets for scalable applications. This Skill provides considerations for implementing these techniques alongside caching to ensure efficient query performance.