Databases Agent Skills

Query PXW_Xref.Data in InterSystems IRIS to find which ObjectScript classes, methods, and properties use or reference another class member.

Migrate to OCI Autonomous Database \u2014 wallet setup, mTLS, Data Pump,\

Complete Odoo backup and restore strategy: database dumps, filestore backup, automated scheduling, cloud storage upload, and tested…

Expert guide for diagnosing and fixing Odoo performance issues: slow queries, worker configuration, memory limits, PostgreSQL tuning, and…

Detect N+1 query anti-patterns specifically — Repo calls inside Enum/for loops, missing preloads on associations.

Trigger system backups, restore from backup files, and manage the SQLite database lifecycle.

Discover and inspect Omni Analytics models, topics, views, fields, dimensions, measures, and relationships using the Omni CLI.

Convert an Omni Analytics topic into a Snowflake Semantic View YAML definition.

Automates the migration of data schemas and system states within the OmniClaw multi-agent ecosystem.

Systematic workflow to catalog, document, optimize, and secure a newly added data source in Dremio.

Design formal knowledge models — classes, properties, relationships, hierarchies, and semantic graphs — for knowledge representation and…

Execute SQL, SPARQL, SPASQL, SPARQL-FED, and GraphQL queries against live data spaces and knowledge graphs via OpenLink's…

Skill for creating custom YesSql indexes in Orchard Core.

Use Databasement when an MCP-compatible agent needs to schedule database backups, supervise restore jobs, enforce retention policy, and…

Outbox Pattern knowledge base. Provides patterns, antipatterns, and PHP-specific guidelines for transactional outbox, polling publisher…

OutSystems SQL query authoring and flowmo database tooling for both O11 (MSSQL) and ODC (Aurora PostgreSQL / ANSI-92).

O11-specific SQL authoring workflow for Flowmo projects.

Guides PostgreSQL development including table design, indexing, constraints, PL/pgSQL, JSONB, full-text search, window functions, CTEs…

Generates comprehensive database design documents and ER diagrams directly from product requirements and API specifications.

pgvector changes since training cutoff (latest: 0.8.2) — halfvec, sparsevec, bit indexing, binary quantization, iterative index scans…

When to activate: PDO, prepared statements, fetch modes, Eloquent query builder, Doctrine, database migrations, N+1 queries, transactions…