skills.rest
AnasAhmed001
AnasAhmed001COMMUNITY
Explore all skills by this author →
Website𝕏@anasxahmed01GitHub

database-specialist

Design scalable SQL and NoSQL database schemas with migrations and indexing.

1|Updated Jan 2, 2026
Search Tags:#query optimization#schema design#database#migrations#ORM#PostgreSQL#MongoDB
One-click install
npx skills add https://github.com/AnasAhmed001/Q4-Hackathon-2 --skill database-specialist
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-specialist
Source: https://github.com/AnasAhmed001/Q4-Hackathon-2/tree/main/phase-2-fullstack-todo-app/.claude/skills/database-specialist
Command: npx skills add https://github.com/AnasAhmed001/Q4-Hackathon-2 --skill database-specialist

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill helps software teams design robust and scalable SQL and NoSQL databases, optimize complex queries, and manage migrations to ensure data integrity and performance.

Core Features & Use Cases

  • Schema design for relational and document stores, including tables/collections, relationships, and indexing strategies.
  • Migration planning and versioning to safely evolve database schemas across environments.
  • Query optimization with indexing, joins, aggregations, and transaction patterns for both PostgreSQL and MongoDB.
  • ORM integration with Prisma, SQLAlchemy, and Mongoose to streamline data access in modern stacks.
  • Performance and design best practices for maintaining data integrity and scalability in production systems.

Quick Start

Design a database schema for a given application, specify whether SQL or NoSQL, and generate the full DDL/DDL-like schema, indexes, and ORM mappings. Then test migrations and ensure queries are optimized for common workloads.

Frequently Asked Questions about database-specialist

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

FAQPage Schema
How do I design a scalable database schema for PostgreSQL and MongoDB?▼

To design a scalable database schema, define your tables or collections, map relationships, and apply indexing strategies to meet performance and consistency requirements. This covers both relational modeling for PostgreSQL and document modeling for MongoDB.

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

Query optimization involves analyzing joins, aggregations, and transaction patterns, then applying proper indexing to reduce execution time. This approach applies to both PostgreSQL relational queries and MongoDB document aggregations.

How do I plan and version database migrations safely across environments?▼

Database migration planning requires versioning schema changes to safely evolve your structures across environments. This ensures data integrity is maintained throughout the deployment lifecycle for both SQL and NoSQL stores.

Can I integrate database schemas with Prisma, SQLAlchemy, and Mongoose ORMs?▼

Yes, ORM integration streamlines data access by mapping your designed schema to application models using Prisma, SQLAlchemy, or Mongoose. This bridges the database schema with modern application stacks efficiently.

When should I choose a SQL versus NoSQL schema for my application?▼

Choosing SQL versus NoSQL schema design depends on whether your application requires relational consistency with PostgreSQL or flexible document modeling with MongoDB. Both approaches include specific indexing and transaction patterns to maintain scalability.

Related Skills

Explore More Software Engineering Skills→
musujmusuj

phase-1-schema

Define project terminology, entities, relationships, and data structures.

Community
Intermediate
neondatabase-labsneondatabase-labs
86

neon-drizzle

Automates Drizzle ORM integration with Neon Postgres, including migrations and type-safe schemas.

Official
Intermediate
AratKruglikAratKruglik
9

nest-data-layer

Detect the ORM in use and apply NestJS data-layer patterns for entities, repositories, transactions, and migrations.

Community
Advanced
SethyPagnaSethyPagna

architecture-diagram

Generate standalone dark-themed architecture diagram HTML files with inline SVG.

Community
Intermediate