SQL & Databases

conardli Bundle

Retrieves and answers questions from a local knowledge base directory by navigating hierarchical index files, then progressively searching Markdown, PDF, and Excel files using grep, Read, pdfplumber, and pandas.

affaan-m Skill

Provides JPA/Hibernate patterns for entity design, relationships, query optimization, transactions, auditing, indexing, pagination, and pooling in Spring Boot.

affaan-m Skill

Provides ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.

affaan-m Skill

Provides MySQL and MariaDB schema, query, indexing, transaction, replication, and connection-pool patterns for production backends.

affaan-m Skill

Quick reference for Redis best practices across common backend use cases, including caching strategies, rate limiting, distributed locks, pub/sub, streams, and connection management.

affaan-m Skill

Provides production patterns and non-obvious traps for Prisma ORM in TypeScript backends, covering schema design, query optimization, transactions, pagination, and common pitfalls.

affaan-m Skill

Provides backend architecture patterns, API design, database optimization, and server-side best practices for Node.js, Express, and Next.js API routes.

affaan-m Skill

Quick reference for PostgreSQL best practices covering query optimization, schema design, indexing, Row Level Security, and connection pooling.

affaan-m Skill

Provides safe, reversible database schema change patterns for PostgreSQL, MySQL, and common ORMs, with guidance on zero-downtime deployments, rollbacks, and migration tooling.

antigravity Skill

Design schemas, write TypeScript functions, set up real-time subscriptions, authentication, file storage, scheduling, and deployment for Convex reactive backend projects.

antigravity Bundle

Perform astronomical research and data analysis with coordinate transformations, unit conversions, FITS file operations, cosmological calculations, time handling, and tabular data manipulation.

antigravity Skill

Master modern SQL with cloud-native databases, OLTP/OLAP optimization, and advanced query techniques. Expert in performance tuning, data modeling, and hybrid analytical systems.

antigravity Skill

Guides database design, implementation, optimization, migrations, data pipelines, and operations for SQL, NoSQL, and modern data platforms.

antigravity Bundle

Search, query, inspect, create, and import data into Weaviate vector database collections using official scripts and references.

antigravity Skill

Provides Python tools for biological computation, including sequence manipulation, file I/O, database access, structural bioinformatics, and phylogenetics.

antigravity Skill

Design PostgreSQL schemas with best practices for data types, indexing, constraints, and performance patterns.

android Bundle

Translates natural language data intents into syntactically valid Perfetto SQL queries and executes them against a local trace file using trace_processor.

dotnet Skill

Optimize Entity Framework Core queries by fixing N+1 problems, choosing correct tracking modes, using compiled queries, and avoiding common performance traps.

oracle Bundle

Provides guidance for Oracle Database administration, SQL and PL/SQL development, performance tuning, security, ORDS, SQLcl, migrations, frameworks, and agent-safe database workflows.

adobe Bundle

Generates a compact KPI digest showing how key metrics changed over a period and what's driving the movement, using Customer Journey Analytics data.

adobe Bundle

Analyze CJA dimensions for cardinality, distribution, trends, anomalies, data quality, comparisons, and forecasting, producing an interactive HTML dashboard or markdown report.

github Skill

Get best practices for Entity Framework Core, covering data context design, entity design, performance, migrations, querying, change tracking, security, and testing.

github Skill

Generate XML configuration files and execute SSMA Console commands for Oracle to SQL Server database migration, including schema conversion and data migration.

github Skill

Guides scaling decisions for Qdrant vector databases based on data volume, query throughput, latency, or query volume.

github Skill

Performs comprehensive SQL code review across all major databases, analyzing security, performance, maintainability, and anti-patterns.

github Bundle

Design, build, and optimize Microsoft Fabric Lakehouse solutions with guidance on core concepts, components, security, shortcuts, and performance optimization.

github Skill

Optimize SQL queries, indexes, and database performance across MySQL, PostgreSQL, SQL Server, and Oracle with execution plan analysis and universal tuning techniques.

github Skill

Integrate Qdrant vector search into applications using officially supported client SDKs for Python, JavaScript, Rust, Go, .NET, and Java.

github Skill

Review PostgreSQL code for best practices, anti-patterns, and quality standards including JSONB, arrays, custom types, schema design, functions, and security features like Row Level Security.

github Skill

Guides embedding model migration in Qdrant without downtime, covering alias swap, side-by-side, and hybrid search strategies.

github Skill

Upgrade Qdrant version without interrupting application availability and ensuring data integrity.

github Skill

Create, alter, and validate Snowflake semantic views using Snowflake CLI, including DDL drafting, validation, and querying.

github Skill

Guides selection of Qdrant deployment options: local mode, Docker, self-hosted, Qdrant Cloud, Hybrid Cloud, or Qdrant EDGE based on latency, control, and production needs.

github Skill

Guides scaling Qdrant query throughput (QPS) through performance tuning, horizontal scaling with read replicas, and disk I/O optimization.

github Skill

Optimize Qdrant vector search performance through indexing strategies, query tuning, memory management, and hardware considerations.

github Skill

Guides optimization of Qdrant query latency by tuning segments, memory, quantization, and search parameters.