SQL & Databases Agent Skills

Design database schemas, plan data migrations, optimize queries, and model data relationships using expert analysis and automated tools.

Translate natural language into SQL queries, optimize database performance, generate migrations, explore schemas, and work with ORMs across PostgreSQL, MySQL, SQLite, and SQL Server.

Manages AlloyDB for PostgreSQL clusters, instances, and backups using gcloud CLI commands.

Run machine learning and generative AI tasks directly in BigQuery SQL using built-in functions for forecasting, anomaly detection, key driver analysis, and text generation.

Provision Bigtable instances, design performant schemas, and query data using gcloud, cbt, or client libraries.

Creates and manages Cloud SQL instances, databases, and users for MySQL, PostgreSQL, and SQL Server using gcloud CLI commands.

Manage Hugging Face Hub resources: download/upload models, datasets, spaces; manage repos, buckets, collections, discussions, and cache; run SQL queries on datasets; authenticate and manage tokens.

Fetch dataset metadata, paginate rows, search text, apply filters, and download parquet URLs from the Hugging Face Dataset Viewer API.

Write correct, efficient Kusto Query Language queries with coverage of syntax, joins, dynamic types, datetime pitfalls, regex, serialization, memory management, and advanced functions.

Execute KQL queries and manage Azure Data Explorer resources for fast, scalable big data analytics on log, telemetry, and time series data.

Provides reference information and CLI commands for Azure Storage services including Blob, File Shares, Queue, Table, and Data Lake, along with guidance on access tiers, redundancy options, and SDK usage.

Provides code examples and guidance for using the Azure Cosmos DB SDK for Java, including setup, authentication, CRUD operations, and querying.

Perform CRUD operations, run queries, and manage containers on Azure Cosmos DB NoSQL API using the Python SDK.

Provides CRUD operations for Azure Cosmos DB NoSQL API from Rust, including document management, container operations, and globally distributed data access.

Build production-grade Azure Cosmos DB NoSQL services with Python/FastAPI, including client setup with dual authentication, service layer CRUD operations, partition key strategies, parameterized queries, and TDD patterns.

Perform CRUD operations, queries, bulk operations, and container management on Azure Cosmos DB NoSQL API using the @azure/cosmos TypeScript/JavaScript SDK.

Build table storage applications using the Azure Tables SDK for Java, supporting both Azure Table Storage and Cosmos DB Table API for NoSQL key-value data.

Provides code samples and best practices for using the Azure Tables SDK for Python to perform NoSQL key-value storage, entity CRUD, batch operations, and queries against Azure Storage Tables or Cosmos DB Table API.

Upload, download, list, and manage blobs and containers in Azure Blob Storage using the Python SDK with best-practice authentication via DefaultAzureCredential.

Upload, download, and manage blobs and containers in Azure Blob Storage using the official Rust SDK.

Connect to Azure Database for PostgreSQL Flexible Server from Node.js/TypeScript using the pg package with support for password and Microsoft Entra ID authentication.

Execute Kusto queries against Log Analytics workspaces and query metrics from Azure resources using the Azure Monitor Query SDK for Java.

Search Azure AI Search indexes using the Python SDK for full-text, vector, hybrid, and semantic search with AI enrichment.

Upload, download, list, and manage blobs and containers in Azure Blob Storage using the @azure/storage-blob SDK.

Extract text, tables, key-value pairs, and structured fields from documents, receipts, invoices, and IDs using Azure AI Document Intelligence SDK for Java.

Build search applications with full-text, vector, semantic, and hybrid search using the Azure AI Search SDK for .NET.

Build search applications with vector, hybrid, and semantic search using the Azure AI Search SDK for TypeScript.

Manage Azure SQL resources (servers, databases, elastic pools, firewall rules, failover groups) using the Azure Resource Manager SDK for .NET.

Manage Azure MySQL Flexible Server deployments using the .NET SDK. Create servers, databases, firewall rules, configurations, backups, and configure high availability.

Manage Azure Cache for Redis instances via the Azure Resource Manager .NET SDK, including creation, firewall rules, access keys, patch schedules, geo-replication, and private endpoints.

Provision and manage Azure Cosmos DB accounts, databases, containers, throughput, and RBAC using the .NET Azure Resource Manager SDK.

Manage Azure PostgreSQL Flexible Server deployments using the .NET SDK. Create servers, databases, firewall rules, configurations, backups, and high availability.

Manage AWS RDS relational databases: provision instances, configure backups, manage replicas, troubleshoot connectivity, and optimize performance.

Design DynamoDB table schemas, write queries, configure indexes, manage capacity, and troubleshoot performance issues using AWS CLI and boto3 examples.

Read and write large cuPyNumeric arrays to HDF5 files using Legate's parallel, distributed HDF5 I/O.

Generate optimized SQL queries from natural language descriptions across multiple database platforms including BigQuery, PostgreSQL, MySQL, and Snowflake. Reads database schemas from uploaded files or diagrams to produce accurate, production-ready queries.