Databases Agent Skills for Zed

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.

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.

Build event streaming and real-time data pipelines with Kafka, Pulsar, Redpanda, Flink, and Spark.

Supabase administration, RLS policies, migrations, and schema design.

This skill should be used when user asks to "use supabase CLI", "supabase init", "supabase start", "run migrations", "deploy edge…