by affaan-m
springboot-patterns helps you design Spring Boot backends with clear controller, service, and repository layers, plus validation, pagination, caching, async processing, profiles, and event-driven flows. Use it as a springboot-patterns guide for Backend Development when you need maintainable production patterns instead of ad hoc Spring code.
by affaan-m
postgres-patterns is a practical PostgreSQL quick-reference skill for query optimization, schema design, indexing, Row Level Security, and connection pooling. It helps Database Engineering workflows make faster, more reliable decisions using compact best practices rather than a generic prompt.
by affaan-m
kotlin-exposed-patterns is a practical guide for Kotlin database engineering with JetBrains Exposed. It covers DSL queries, DAO pattern, newSuspendedTransaction, HikariCP, Flyway migrations, and repository boundaries for maintainable data access.
by affaan-m
jpa-patterns is a practical JPA/Hibernate guide for Spring Boot backend development. It covers entity design, relationships, query tuning, transactions, auditing, pagination, and pooling to help reduce ORM mistakes and improve persistence performance.
by affaan-m
django-patterns is a practical guide for Django architecture patterns, including DRF APIs, ORM usage, caching, signals, middleware, and split settings. It helps backend teams standardize project structure and build maintainable apps with fewer guesses.
by affaan-m
The database-migrations skill helps backend teams plan safe schema changes, data backfills, rollbacks, and zero-downtime deploys for PostgreSQL, MySQL, and common ORMs. Use it for production-safe database-migrations guide work when you need clear steps, fewer locks, and reversible changes.
by affaan-m
clickhouse-io is a ClickHouse-focused skill for schema design, analytical SQL, ingestion patterns, and performance tuning. Use it to guide MergeTree choices, partitioning, materialized views, and workload-specific query optimization.
by affaan-m
backend-patterns is a backend development skill for Node.js, Express, and Next.js API routes. It helps with API design, repository/service/controller layering, validation, caching, background jobs, and database optimization so you can build cleaner server-side systems with less guesswork.
by wshobson
similarity-search-patterns helps you choose distance metrics, index types, and hybrid retrieval patterns for semantic search and RAG workflows. Use it to plan production vector search tradeoffs around recall, latency, and scale.
by wshobson
sql-optimization-patterns helps diagnose slow SQL with EXPLAIN analysis, indexing strategy, join tuning, pagination fixes, and practical query rewrite guidance for database engineering teams.
by wshobson
dbt-transformation-patterns helps agents structure dbt projects with staging, intermediate, and marts layers, plus testing, documentation, and incremental model guidance. Use it to plan installs, scaffold new repos, or refactor SQL into cleaner analytics engineering patterns for Database Engineering teams.
by wshobson
postgresql-table-design helps agents design or review PostgreSQL schemas with practical rules for keys, normalization, data types, constraints, foreign key indexes, and PostgreSQL-specific gotchas.
by wshobson
projection-patterns helps teams design CQRS read models and event-stream projections, with practical guidance on projection types, replay, checkpointing, and usage for Backend Development.
by wshobson
cqrs-implementation helps backend teams design CQRS architectures, separate command and query models, and plan read/write scaling, events, and gradual adoption.
by wshobson
event-store-design helps Backend Development teams design event stores for event-sourced systems, covering streams, ordering, concurrency, snapshots, metadata, subscriptions, and operational tradeoffs. Use it to shape a practical event store design before implementation.
by wshobson
database-migration helps plan and generate schema and data migrations across ORM and SQL workflows, with rollback safety, phased rollouts, and zero-downtime guidance for production Database Engineering teams.
by phuryn
The sql-queries skill turns business questions and rough analytics goals into optimized SQL for BigQuery, PostgreSQL, MySQL, and other dialects. It reads schema context, clarifies filters and aggregations, and helps with sql-queries for Data Analysis, reporting, and exploration.
by microsoft
azure-storage-queue-ts is a practical skill for Azure Queue Storage in TypeScript and JavaScript. It helps backend developers send, receive, peek, and delete queue messages with the right auth, environment setup, and client types. Use it as a focused azure-storage-queue-ts guide for reliable message queue operations.
by microsoft
azure-search-documents-ts helps backend developers build Azure AI Search solutions with the @azure/search-documents SDK. Use it for index creation, document upload, keyword, vector, hybrid, and semantic search, plus credential and environment setup. It is a practical azure-search-documents-ts guide for backend development.
by microsoft
azure-postgres-ts helps Node.js and TypeScript apps connect to Azure Database for PostgreSQL Flexible Server with pg. Use it for backend services, API routes, workers, pooling, transactions, and password or Microsoft Entra ID auth. This azure-postgres-ts skill is a practical azure-postgres-ts guide for backend development.
by microsoft
azure-cosmos-ts is a practical guide for using the @azure/cosmos TypeScript SDK in backend development. It focuses on data-plane CRUD, parameterized queries, bulk operations, partition keys, and auth setup for existing Cosmos DB accounts. Use it when you need the azure-cosmos-ts skill for reliable document access, not Azure resource provisioning.
by microsoft
azure-cosmos-rust is the Azure Cosmos DB NoSQL skill for Rust projects. It covers install-ready guidance, official crate selection with azure_data_cosmos, COSMOS_ENDPOINT setup, authentication, partition-aware CRUD, and RoutingStrategy for Database Engineering workflows.
by microsoft
pydantic-models-py helps you create Pydantic v2 multi-model sets with Base, Create, Update, Response, and InDB variants. Use it for backend development, API request and response schemas, PATCH-friendly updates, camelCase aliases, and database-ready Python models.
by microsoft
azure-storage-file-datalake-py is the Python skill for Azure Data Lake Storage Gen2. It helps backend developers and agents install, authenticate, and use the Azure SDK for hierarchical file system tasks like listing, uploading, downloading, and managing directories and files.
