Database Management skills
Backend Migration Standards
Creates and manages database migrations with reversible changes, proper naming conventions, and zero-downtime deployment strategies.
Database Management21312 ptsBackend Models Standards
Defines robust and maintainable database models with clear naming, appropriate data types, constraints, and relationships.
Database Management21312 ptsPostGIS Geospatial Development
Implements best practices for querying and managing geospatial data in PostgreSQL with PostGIS.
Database Management12 ptsSupabase Database Integration
Query and interact with Supabase databases using real-time subscriptions and PostgreSQL-compatible syntax while respecting Row Level Security policies.
Database Management12 ptsSQL Query Optimization
Optimizes PostgreSQL database performance through structured analysis, index recommendations, and advanced query refactoring patterns.
Database Management12 ptsDatabase Operations
Streamlines database interactions by providing standardized patterns for CRUD operations, session management, and performance optimization.
Database Management12 ptsDatabase Connection Pooling
Optimizes database performance and reliability by configuring robust connection pools for SQLAlchemy across traditional and serverless architectures.
Database Management12 ptsPostgreSQL Database Manager
Manages PostgreSQL database connections and executes secure SQL queries with automated schema introspection and result formatting.
Database Management12 ptsAlembic Migration Manager
Manages database schema and data migrations using Alembic through standardized workflows and production-ready best practices.
Database Management12 ptsFrappe DocType Builder
Constructs complete DocType definitions for the Frappe Framework, including fields, permissions, and configurations.
Database Management112 ptsMySQL Database Skill
Executes safe SELECT queries against MySQL and MariaDB databases with built-in connection pooling and SQL injection prevention.
Database Management12 ptsRedis Cache Management
Manages Redis cache operations including key-value manipulation, production-safe pattern searching, and TTL inspection.
Database Management12 ptsElasticsearch & OpenSearch
Integrates Elasticsearch and OpenSearch for complex search queries, data aggregations, and comprehensive index management.
Database Management12 ptsClickHouse Cloud Management
Manages ClickHouse Cloud users, permissions, and connections using SQL over the HTTP interface.
Database Management112 ptsBazinga Database Operations
Manages concurrent-safe database operations for the BAZINGA multi-agent development system.
Database Management112 ptsSQL Batching
Prevents D1/SQLite 'too many SQL variables' errors by automatically batching Drizzle ORM queries with dynamic arrays.
Database Management12 ptsQuery Performance Analysis
Analyzes database query performance, detects N+1 issues, identifies missing indexes, and guides safe index migrations.
Database Management12 ptsInstantDB
Provides expert guidance and best practices for building, debugging, and querying with the InstantDB real-time database.
Database Management12 ptsDuckDB SQL
Generates and refines DuckDB SQL queries for data analysis using local database, CSV, and Parquet files.
Database Management12 pts