Connect READ-ONLY to a Europharmacy / Euromedica pharmacy SQL Server and run sales / product / stock queries.
Generates Event Store pattern for PHP 8.4.
Use when writing raw SQL — MariaDB/MySQL syntax, parameterization, raw migrations, seeders with `DB::statement`; fires even on a pasted…
Design, implement, or review compatible and reversible database, event, API payload, configuration, or persisted-data schema evolution.
This skill should be used when the user asks to "rename a column without downtime", "drop a column safely", "add NOT NULL to a live…
Visualize and analyze DataFusion query execution plans.
Connect to and federate external PostgreSQL, MySQL, and SQLite databases with DuckDB.
Use when the user needs to filter data — whether in a structured query, a metric aggregation, or an attribute expression.
Manages Firebase/Firestore operations including CRUD, queries, batch processing, A2A agent communication, MCP server integration, and…
Analyze and consolidate Flyway SQL migrations into clean, domain-grouped CREATE TABLE migrations for pre-production projects.
Conventions and checklist for authoring Flyway SQL migrations (Postgres, Flyway-managed schema).
Expert in event sourcing, CQRS, and event-driven architecture patterns.
Frappe customization-surface guidance covering Custom Field, Property Setter, Client Script, Server Script, Workspace, Web Page, Page…
Frappe DocType creation and form UX guidance.
Manage the freshie ecosystem inventory database \u2014 a CMDB tracking\
Optimize AgentDB performance with quantization (4-32x memory reduction), HNSW indexing (150x faster search), caching, and batch operations.
Implement Command Query Responsibility Segregation for scalable architectures.
Guides PostgreSQL development including table design, indexing, constraints, PL/pgSQL, JSONB, full-text search, window functions, CTEs…
PostgreSQL database patterns for query optimization, schema design, indexing, and security.
Design a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns, and advanced features