Database Management skills
PostGIS 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 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 ptsMySQL Database Skill
Executes safe SELECT queries against MySQL and MariaDB databases with built-in connection pooling and SQL injection prevention.
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 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 ptsDuckDB SQL
Generates and refines DuckDB SQL queries for data analysis using local database, CSV, and Parquet files.
Database Management12 pts