Databases Agent Skills for Microsoft Copilot

To build Solr phrase-tagging semantic search: concept tagging, taxonomy, graph paths.

Analyze data source characteristics including update frequency, volume patterns, and schema stability.

Comprehensive guide to Spark Structured Streaming for production workloads.

Spring Boot 4 data layer implementation for Domain-Driven Design.

Use when reviewing or creating SQL for analysis, metric definitions, joins, filters, aggregation, and validation queries.

Craft and optimize SQL for any warehouse dialect — Snowflake, BigQuery, Databricks, Redshift, PostgreSQL.

/============================================================================/ / SQL-DATABASE-SPECIALIST SKILL :: VERILINGUA x VERIX…

Transform slow database queries into lightning-fast operations through systematic optimization, proper indexing, and query plan analysis.

Advanced SQL patterns including window functions, CTEs, recursive queries, and optimization techniques.

Analyze SQL files for performance issues like full table scans, ineffective joins, and inefficient queries.

Explains, optimises, writes, and documents SQL queries.

SQL query optimization patterns including EXPLAIN plan analysis, index strategies, query rewriting, and N+1 query prevention.

Analyzes SQL performance, interprets execution plans, and provides actionable optimization strategies for databases and ORMs.

Expert in Microsoft SQL Server development and administration.

Translates natural language to SQL, analyzes query anti-patterns, and interprets EXPLAIN execution plans for SQLite and PostgreSQL.

SQLAlchemy 2.0 async patterns with AsyncSession, async_sessionmaker, and FastAPI integration.

SQLAlchemy 2.0 patterns - model definition, engine setup, async patterns, relationships, query optimization, repository pattern, and…

SQLAlchemy ORM patterns for Python database access.

SQLite changes since training cutoff (latest: 3.51.0) — JSON enhancements, new SQL functions, FTS5 locale support, date modifiers, JSONB…

SQLiteCpp coding standards and API rules for core edits, public headers, style, and Doxygen.

Wrap JSON-backed database columns with ActiveModel-like classes using store_model.