Skill UI

Java SDK for Azure Cosmos DB that orchestrates NoSQL operations with reactive patterns, multi-model support, and global distribution, covering client setup, CRUD flows, queries, and consistency/partition guidance for modern cloud apps.

Provides the TypeScript/JavaScript data plane SDK for Azure Cosmos DB, enabling CRUD, queries, bulk operations, and container management through CosmosClient. Ideal for Node.js apps authenticating with DefaultAzureCredential or keys to work with NoSQL documents, stored procedures, and cross-partition workloads.

Client library for Azure Storage and Cosmos DB tables, letting Python apps manage tables, CRUD partitioned entities, run parameterized queries, and submit batch or async operations for scalable NoSQL key-value workloads.

Provides Node.js/TypeScript guidance for connecting to Azure Database for PostgreSQL Flexible Server with the pg package, covering password and Microsoft Entra ID auth, pool management, parameterized queries, and transaction helpers.

Analyzes diffs, architecture, and tests to spot bugs, SQL injection, XSS, N+1 queries, and maintainability smells, then produces prioritized, actionable reports ideal for PR reviews, quality audits, and refactoring planning.

Actionable guidance for analyzing plans, indexing, connection pooling, partitioning, and detecting N+1 queries to keep PostgreSQL and MySQL workloads fast and reliable.

Guides PostgreSQL and MySQL performance investigations by analyzing slow queries, EXPLAIN plans, index strategies, and configuration tuning, plus resolving lock contention to improve scalability.

Optimizes Databricks spending by combining policy enforcement, spot instances, autoscaling, and monitoring queries and clusters to trim DBU costs while keeping workloads responsive.

Detect SQL injection weaknesses by running the sql-injection-detector plugin against codebases, identifying risky queries, and providing remediation guidance to secure applications.

Analyzes SQL statements, identifies bottlenecks, suggests indexes and rewrites, and leverages the sql-query-optimizer plugin so you can improve database responsiveness when queries run slowly.

A comprehensive resource providing best practices for PostgreSQL performance optimization, schema design, and security configuration. Developed by Supabase, it covers critical areas like query performance, connection management, and Row-Level Security. Use this skill when writing complex SQL queries, reviewing schema integrity, or diagnosing database bottlenecks to ensure high performance and stability.

This skill provides systematic patterns and best practices for transforming slow database queries into lightning-fast operations. It covers advanced topics such as proper indexing strategies, detailed query plan analysis (EXPLAIN), resolving common issues like N+1 problems, and designing highly performant database schemas. Use this when debugging performance bottlenecks, improving application response times, or ensuring scalability for growing datasets.