Databases Agent Skills for Microsoft Copilot

Time-series database implementation for metrics, IoT, financial data, and observability backends.

When to activate: TimescaleDB, InfluxDB, time series, time-bucketing, continuous aggregates, retention, metrics storage

Use this skill to analyze an existing PostgreSQL database and identify which tables should be converted to Timescale/TimescaleDB…

Use this skill when creating database schemas or tables for Timescale, TimescaleDB, TigerData, or Tiger Cloud, especially for time-series…

MANDATORY when working with time-series data, hypertables, continuous aggregates, or compression - enforces TimescaleDB 2.24.0 best…

Tinybird file formats, SQL rules, optimization patterns, and best practices for datasources, pipes, endpoints, and materialized views.

Tinybird TypeScript SDK for defining datasources, pipes, and queries with full type inference.

Checks transaction scope, missing rollback handling, long-held transactions, trigger/notify interaction.

This skill should be used when the user asks "which isolation level do I need", "why did concurrent requests break this invariant"…

ACID properties, isolation levels, locks, deadlocks, and transaction design.

Wrap multi-write operations in transactions; use dispatchAfterCommit and idempotency patterns to ensure consistency

Design and review transaction boundaries, isolation, locking, retries, and consistency for backend workflows.

Diagnoses common datavault4dbt failures — satellites capturing too many or too few rows, multi-source high-water-mark issues…

Automate Turso tasks via Rube MCP (Composio).

TypeORM migration patterns

Optimize slow analytical SQL by reading query/EXPLAIN plans, cutting scanned data, fixing join strategy, and using partitioning…

Provision a zero-config, no-signup, temporary Upstash Redis database for an AI agent with a single POST to…

In-memory caching in Golang using samber/hot — eviction algorithms (LRU, LFU, TinyLFU, W-TinyLFU, S3FIFO, ARC, TwoQueue, SIEVE, FIFO)…

usql is a universal command-line interface for SQL databases including PostgreSQL, MySQL, SQLite, Oracle, SQL Server, and dozens more.

Connect to live PostgreSQL database to validate schema assumptions, compare pg_dump vs pgschema output, and query system catalogs…

This skill utilizes the data-validation-engine plugin to ensure database integrity.