Guides MySQL/MariaDB query design, indexing strategy, data types, and concurrency patterns — the InnoDB-specific counterpart to…
Diagnosing N+1 query patterns in Rails/Grape: slow index pages, serializers, nested API responses.
Implement incremental sync strategies for Navan BOOKING and TRANSACTION
Implement data quality validation with Great Expectations, dbt tests, and data contracts.
Neo4j CLI. Runs and pipes Cypher, introspects the schema, generates a data model, and embeds text inline as a query parameter. Discovers…
When to activate: Neo4j, Cypher, graph database, nodes, relationships, APOC, graph algorithms, knowledge graph
Automate Neon serverless Postgres operations -- manage projects, branches, databases, roles, and connection URIs via the Composio MCP…
S3-compatible object storage that branches with your Neon project, so files and the database stay in sync across every branch.
Configures Neon Serverless Driver for Next.js, Vercel Edge Functions, AWS Lambda, and other serverless environments.
Overview of Neon, a complete set of cloud backend primitives around Lakebase Postgres: Auth, Object Storage, Functions, and the AI Gateway.
Expert database administrator specializing in modern cloud databases, automation, and reliability engineering.
Design a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns, and advanced features
Master modern SQL with cloud-native databases, OLTP/OLAP optimization, and advanced query techniques.
Automate Ninox tasks via Rube MCP (Composio).
Write, review, debug, parse, or generate Obelisk urQL — the SQL dialect of the Obelisk RDBMS Gall agent.
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.