database-specialist

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.