GitHub
query-optimization
SQL query optimization and performance tuning
☆ 2View skill
Databases AI Skills
Discover Databases skills, compare source repositories and read the instructions for each workflow.
Categories: Databases
Databases Clear filters
Browse skills
GitHub
migrations
Database schema migrations and version control
☆ 2View skill
GitHub
redis
Redis data structures and commands including strings, lists, hashes, sets, sorted sets, streams, and transactions for high-performance caching and real-time applications.
☆ 2View skill
GitHub
data-analysis-sql
SQL for data analysis with exploratory analysis, advanced aggregations, statistical functions, outlier detection, and business insights. 50+ real-world analytics queries.
☆ 2View skill
GitHub
bi-fundamentals
BI fundamentals with metric definition, KPI calculation, dimensional modeling, dashboard optimization, and data storytelling. 40+ metric examples and calculation patterns.
☆ 2View skill
GitHub
postgresql
PostgreSQL administration and setup including installation, configuration, backup/recovery, replication, and high-availability. Learn production PostgreSQL operations.
☆ 2View skill
GitHub
data-warehouse
Data warehouse design mastery with star schema, dimensional modeling, fact/dimension tables, slowly changing dimensions, and enterprise best practices. Complete schema examples included.
☆ 2View skill
GitHub
sql-fundamentals
Master SQL fundamentals including SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, DROP operations. Learn data types, WHERE clauses, ORDER BY, GROUP BY, and basic joins.
☆ 2View skill
GitHub
mongodb
MongoDB fundamentals including document model, CRUD operations, querying, indexing, and aggregation framework for NoSQL database applications.
☆ 2View skill
GitHub
spring-microservices
Build cloud-native microservices - service discovery, config server, API gateway, resilience patterns
☆ 2View skill
GitHub
spring-rest-api
Build production-ready REST APIs with Spring MVC - controllers, validation, exception handling, OpenAPI
☆ 2View skill
GitHub
spring-boot-basics
Comprehensive guide to Spring Boot fundamentals - auto-configuration, starters, properties, and profiles
☆ 2View skill
GitHub
spring-data-jpa
Master Spring Data JPA - repositories, queries, relationships, transactions, and performance
☆ 2View skill
GitHub
spring-reactive
Build reactive applications - WebFlux, Mono/Flux, R2DBC, backpressure, reactive streams
☆ 2View skill
GitHub
spring-testing
Test Spring Boot applications - MockMvc, TestContainers, test slices, integration testing
☆ 2View skill
GitHub
spring-security
Secure Spring Boot applications - authentication, authorization, OAuth2, JWT, CORS/CSRF protection
☆ 2View skill
GitHub
design-patterns
Identify, implement, and teach GoF design patterns
☆ 2View skill
GitHub
solid-principles
Apply and validate SOLID principles in object-oriented design
☆ 2View skill
GitHub
architecture-patterns
Design, evaluate, and document software architecture patterns
☆ 2View skill
GitHub
refactoring
Detect code smells and apply safe refactoring techniques
☆ 2View skill
GitHub
clean-code
Analyze and improve code quality, readability, and maintainability
☆ 2View skill
GitHub
domain-driven-design
Model business domains using DDD tactical and strategic patterns
☆ 2View skill
GitHub
tdd-practices
Guide TDD workflow, design tests, and create mocking strategies
☆ 2View skill
GitHub
prompt-injection
Prompt injection attack prevention and defense
☆ 2View skill
The default order uses GitHub repository stars from our indexed data. Stars belong to the source repository and may be shared by multiple skills. They indicate repository interest, not skill installs or an independent quality score.