skills.rest
AdelysAlberto
AdelysAlbertoCOMMUNITY
Explore all skills by this author →
Website𝕏@adelysalbertoGitHub

db

Designs SQL and NoSQL schemas, indexes, ORM mappings, and query optimizations.

1|Updated Jul 18, 2025
Search Tags:#query optimization#schema design#database#redis#sql#orm#nosql
One-click install
npx skills add https://github.com/AdelysAlberto/md-configs-and-agents --skill db-adelysalberto
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: db
Source: https://github.com/AdelysAlberto/md-configs-and-agents/tree/main/agents-antigravity/config/skills/db
Command: npx skills add https://github.com/AdelysAlberto/md-configs-and-agents --skill db-adelysalberto

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Designing efficient database schemas and optimizing queries requires specialized knowledge of SQL, NoSQL, indexing strategies, and ORM patterns that many developers lack time to master. ## Core Features & Use Cases - Schema Design: Creates SQL and NoSQL database schemas tailored to application data models. - Query Optimization: Designs indexes and optimizes queries for relational databases and Redis caching layers. - ORM Guidance: Provides ORM configuration and data engineering best practices. - Use Case: When building a new application backend, invoke this Skill to generate a normalized PostgreSQL schema with proper indexes and a Redis caching strategy for frequently accessed data. ## Quick Start Ask the agent to design a database schema with indexes and query optimization recommendations for your application's data model.

Frequently Asked Questions about db

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

FAQPage Schema
How do I design a database schema for a new application?▼

Invoke this Skill with a description of your application's entities and relationships. It generates SQL or NoSQL schema designs including tables, relationships, and data types suited to your data model.

How to optimize slow SQL queries with indexes?▼

The Skill analyzes query patterns and recommends index strategies such as composite or covering indexes. It covers both relational database indexing and Redis-based caching for frequently accessed data.

Does this Skill support NoSQL databases like MongoDB?▼

Yes, the Skill covers both SQL and NoSQL schema design according to its description. It handles document-oriented data modeling alongside traditional relational schemas.

Can it help with ORM configuration and setup?▼

Yes, ORM design is listed as a core capability. The Skill provides guidance on mapping application objects to database tables and structuring data access layers.

When should I use Redis caching with my database?▼

Use Redis caching when queries repeatedly fetch the same data or when read latency is critical. The Skill recommends caching strategies as part of its query optimization workflow.

Related Skills

Explore More Software Engineering Skills→
hpsgdhpsgd

data-model

Design data models defining entities, relationships, constraints, and access patterns.

Official
Advanced
maksimzayatsmaksimzayats
200

specx-sqlalchemy-migrations

Automate Alembic migration creation and maintenance for Specx SQLAlchemy services.

Community
Intermediate
appliedailearnerappliedailearner

azure-sql-database

Diagnose and design Azure SQL Database solutions for performance, security, and deployment.

Community
Advanced
ollieb89ollieb89

database-design

Generate SQLAlchemy models, Alembic migrations, and Pydantic schemas from field definitions.

Community
Intermediate