Databases
SQL, NoSQL, and database management skills
4429 skills in this category
Subcategories
managing-database-tests
Database testing including fixtures, transactions, and rollback management.Use when performing specialized testing.Trigger with phrases like "test the database", "run database tests", or "validate data integrity".
genkit-production-expert
Build production Firebase Genkit applications including RAG systems, multi-step flows, and tool calling for Node.js/Python/Go. Deploy to Firebase Functions or Cloud Run with AI monitoring. Use when asked to "create genkit flow" or "implement RAG". Trigger with relevant phrases based on skill purpose.
monitoring-error-rates
Monitor and analyze application error rates to improve reliability. Use when tracking errors in applications including HTTP errors, exceptions, and database issues. Trigger with phrases like "monitor error rates", "track application errors", or "analyze error patterns".
exploring-blockchain-data
Query and analyze blockchain data including blocks, transactions, and smart contracts.Use when querying blockchain data and transactions.Trigger with phrases like "explore blockchain", "query transactions", or "check on-chain data".
automating-database-backups
Use when you need to automate database backup processes with scheduling and encryption.This skill creates backup scripts for PostgreSQL, MySQL, MongoDB, and SQLite with compression.Trigger with phrases like "automate database backups", "schedule database dumps","create backup scripts", or "implement disaster recovery for database".
generating-test-data
Generate realistic test data including edge cases and boundary conditions.Use when creating realistic fixtures or edge case test data.Trigger with phrases like "generate test data", "create fixtures", or "setup test database".
aggregating-performance-metrics
Aggregate and centralize performance metrics from applications, systems, databases, caches, and services. Use when consolidating monitoring data from multiple sources. Trigger with phrases like "aggregate metrics", "centralize monitoring", or "collect performance data".
validating-database-integrity
Use when you need to ensure database integrity through comprehensive data validation.This skill validates data types, ranges, formats, referential integrity, and business rules.Trigger with phrases like "validate database data", "implement data validation rules","enforce data integrity constraints", or "validate data formats".
generating-stored-procedures
Use when you need to work with stored procedure generation.This skill provides stored procedure code generation with comprehensive guidance and automation.Trigger with phrases like "generate stored procedures", "create database functions",or "write SQL procedures".
comparing-database-schemas
Use when you need to work with schema comparison.This skill provides database schema diff and sync with comprehensive guidance and automation.Trigger with phrases like "compare schemas", "diff databases",or "sync database schemas".
detecting-database-deadlocks
Use when you need to work with deadlock detection.This skill provides deadlock detection and resolution with comprehensive guidance and automation.Trigger with phrases like "detect deadlocks", "resolve deadlocks",or "prevent deadlocks".
optimizing-sql-queries
Use when you need to work with query optimization.This skill provides query performance analysis with comprehensive guidance and automation.Trigger with phrases like "optimize queries", "analyze performance",or "improve query speed".
analyzing-query-performance
Use when you need to work with query optimization.This skill provides query performance analysis with comprehensive guidance and automation.Trigger with phrases like "optimize queries", "analyze performance",or "improve query speed".
generating-rest-apis
Generate complete REST API implementations from OpenAPI specifications or database schemas.Use when generating RESTful API implementations.Trigger with phrases like "generate REST API", "create RESTful API", or "build REST endpoints".
tracking-application-response-times
Track and optimize application response times across API endpoints, database queries, and service calls. Use when monitoring performance or identifying bottlenecks. Trigger with phrases like "track response times", "monitor API performance", or "analyze latency".
modeling-nosql-data
Use when you need to work with NoSQL data modeling.This skill provides NoSQL database design with comprehensive guidance and automation.Trigger with phrases like "model NoSQL data", "design document structure",or "optimize NoSQL schema".
managing-database-partitions
Use when you need to work with database partitioning.This skill provides table partitioning strategies with comprehensive guidance and automation.Trigger with phrases like "partition tables", "implement partitioning",or "optimize large tables".
collecting-infrastructure-metrics
Collect comprehensive infrastructure performance metrics across compute, storage, network, containers, load balancers, and databases. Use when monitoring system performance or troubleshooting infrastructure issues. Trigger with phrases like "collect infrastructure metrics", "monitor server performance", or "track system resources".
monitoring-database-health
Use when you need to work with monitoring and observability.This skill provides health monitoring and alerting with comprehensive guidance and automation.Trigger with phrases like "monitor system health", "set up alerts",or "track metrics".
scanning-database-security
Use when you need to work with security and compliance.This skill provides security scanning and vulnerability detection with comprehensive guidance and automation.Trigger with phrases like "scan for vulnerabilities", "implement security controls",or "audit security".