skills.rest
Muath2000
Muath2000COMMUNITY
Explore all skills by this author →
GitHub

database-architect

Designs and optimizes PostgreSQL, Redis, and Elasticsearch database architectures and queries.

Updated Feb 22, 2026
Search Tags:#query optimization#schema design#database#scalability#postgresql#redis#multi-tenancy
One-click install
npx skills add https://github.com/Muath2000/TradeStation --skill database-architect-muath2000
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-architect
Source: https://github.com/Muath2000/TradeStation/tree/main/.claude/skills/database-architect
Command: npx skills add https://github.com/Muath2000/TradeStation --skill database-architect-muath2000

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve?

This Skill addresses complex database challenges, from initial schema design and advanced query optimization to implementing robust multi-tenant strategies, sharding, and disaster recovery plans.

Core Features & Use Cases

  • Schema Design: Designs normalized (3NF) or strategically denormalized schemas with clear naming conventions and essential columns.
  • Performance Tuning: Optimizes queries using EXPLAIN ANALYZE, advanced indexing, and partitioning strategies.
  • Scalability: Implements multi-tenant isolation (shared DB, schema-per-tenant, DB-per-tenant), sharding, and replication.
  • Use Case: A SaaS company needs to design a new PostgreSQL database for a multi-tenant application. The database architect will define the schema, set up Row-Level Security for data isolation, and plan for future scaling with partitioning and connection pooling.

Quick Start

Design a PostgreSQL schema for a multi-tenant SaaS application, including tables for tenants, users, products, and orders, following 3NF principles and implementing Row-Level Security.

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 PostgreSQL schema for a multi-tenant SaaS application?▼

Designing a PostgreSQL multi-tenant schema involves creating normalized 3NF tables for tenants and users, implementing Row-Level Security for data isolation, and planning future scaling with partitioning and connection pooling.

What is the best way to optimize slow PostgreSQL queries?▼

The best way to optimize slow PostgreSQL queries is using EXPLAIN ANALYZE to inspect execution plans, applying advanced indexing strategies, and implementing table partitioning to reduce scan overhead.

Does this database architect support Drizzle ORM and raw SQL?▼

Yes, the database architect supports both Drizzle ORM and raw SQL, allowing you to design schemas, implement multi-tenant strategies, and optimize queries across either approach.

How do I implement sharding and replication for database scalability?▼

Implementing database scalability requires configuring sharding to distribute data horizontally across multiple nodes and setting up replication to ensure high availability and read scaling.

When should I use Redis versus PostgreSQL for my database architecture?▼

Use Redis for high-speed caching and session management, while PostgreSQL handles persistent relational data, schema design, and complex queries, with both supporting scalable multi-tenant application architectures.

How do I set up a disaster recovery and backup plan for PostgreSQL?▼

Setting up a PostgreSQL disaster recovery plan involves configuring automated backups, establishing replication for redundancy, and defining recovery point objectives to restore operations after failure.

Related Skills

Explore More Software Engineering Skills→
alceupassosalceupassos

drizzle

Manage PostgreSQL schemas and optimize queries with Drizzle ORM.

Community
Advanced
erikstmartinerikstmartin
16

postgres

Optimize PostgreSQL schemas, queries, and operations for reliability and performance.

Community
Advanced
derek2035derek2035

cloudbase-cli

Manage CloudBase resources via the tcb CLI for deployment and configuration.

Community
Intermediate
HouseGarofaloHouseGarofalo
3

database-architect-agent

Guide database architecture, data modeling, schema optimization, and query performance tuning.

Official
Advanced