PostgreSQL plugins

Design and implement backend systems with REST/GraphQL APIs, microservices, event sourcing, CQRS, and Temporal workflows, including testing, security auditing, and performance optimization.

Design and optimize database schemas, SQL queries, and data architectures across PostgreSQL, MySQL, MongoDB, and cloud data warehouses with expert guidance on indexing, constraints, and performance tuning for production systems. Handles greenfield schema design and re-architecture projects.

Master essential developer skills including Git workflows, SQL optimization, error handling, code review, E2E testing, authentication, debugging, and monorepo management with Nx, Turborepo, and Bazel.

Build production data pipelines with Apache Airflow, dbt, and Spark, including vector database integration for RAG systems and embedding model optimization.

Orchestrates end-to-end full-stack feature development with specialized agents for architecture, implementation, testing, security, performance, and deployment, using an API-first approach and interactive checkpoints.

Develop, deploy, and maintain Odoo ERP systems: Docker-based infrastructure, custom module development, ORM query patterns, performance tuning, eCommerce and Sales/CRM workflows, and security access control.

Develop production-ready Python backends with async patterns, modern frameworks (FastAPI, Django), and best practices for architecture, testing, and performance.

Guides full-stack development with opinionated best practices for API design (REST/GraphQL/tRPC), layered backend architecture (Express/TypeScript/Prisma), database schema and ORM selection, React/Next.js frontend components, and Stripe payment integration. Includes project scaffolding and code quality checks.

Implement production observability with Prometheus metrics, Grafana RED/USE dashboards, distributed tracing via Jaeger/Tempo, and SLO/error-budget management. Includes agents for performance profiling, database tuning, and network optimization.

Scaffolds production-ready REST and GraphQL APIs with framework selection (FastAPI, Django), async patterns, dependency injection, microservices architecture, and scalable backend design.

Automate database migrations with zero-downtime SQL scripts, observability via CDC pipelines and Grafana, and expert DBA agents for multi-cloud operations, performance tuning, and reliability engineering across PostgreSQL, MySQL, MongoDB, and more.

Design and implement Domain-Driven Design architectures with CQRS, event sourcing, and saga patterns for complex business domains and distributed systems.

Plan and execute safe, incremental codebase migrations across frameworks, languages, and databases—covering AngularJS-to-Angular upgrades, React modernization, database schema migrations, and dependency version management—with automated risk assessment, rollback strategies, and legacy system modernization using the strangler fig pattern.

End-to-end AI and data engineering suite covering data pipelines, ML model development, LLM architecture, MLOps, database optimization, and prompt engineering for production systems.

Guides developers through the full lifecycle of launching and monetizing a SaaS product, from MVP development and payment integration to product analytics, email marketing, referral programs, pricing strategies, and SEO optimization.

Build and optimize data analytics workflows: enforce A/B testing gates, audit tracking systems, design data layers, tune SQL queries across Postgres/Snowflake/BigQuery/DuckDB, and create d3.js visualizations.

Manage cloud infrastructure, deployment pipelines, and production operations across AWS, Azure, and GCP with specialized agents for Terraform, Kubernetes, CI/CD, incident response, security hardening, and database administration.

Optimize database performance and cloud infrastructure costs across AWS, Azure, and GCP. Design scalable data layers, tune SQL/NoSQL queries, and implement cost-effective cloud architectures.

Enables end-to-end data engineering: orchestrating Airflow DAGs, transforming data with dbt, optimizing Postgres/SQL performance, and implementing vector search and RAG pipelines for AI/ML applications.

Enables end-to-end data analytics workflows: design tracking systems, validate data quality with dbt, optimize SQL and Postgres performance, run structured A/B tests, and transform raw data into executive-ready narratives.

Build and orchestrate production data pipelines with Airflow, dbt, and Spark, including data quality validation, streaming architectures, and vector database integration for RAG systems.

Provides a complete data analytics workflow from tracking and modeling to dashboards and visualization, including A/B testing, product analytics, predictive modeling, and dbt pipeline patterns.

Design and implement Domain-Driven Design architectures with CQRS, event sourcing, and saga patterns for complex business domains and distributed systems.

Enables full-stack development with guided patterns for API design, authentication, backend architecture, database schema, React/Next.js frontend, testing, and Stripe payment processing.

Develop and deploy Odoo ERP applications with skills for Docker infrastructure, custom module scaffolding, ORM querying, performance optimization, and business configurations (eCommerce, CRM, sales).

Design, build, and document production-ready Python APIs with FastAPI and Django, including async patterns, OpenAPI spec generation, Pydantic models, and testing strategies.

Build production-ready Python backends with async patterns, FastAPI/Django architecture, testing strategies, and modern tooling (uv, ruff, pydantic). Guides framework selection, project structure, and performance optimization for Python 3.12+ applications. Includes async web APIs, microservices, real-time systems, and TDD workflows.

Write SQL, explore datasets, and generate insights faster. Build interactive dashboards and publication-quality visualizations, then QA and present findings to stakeholders.

Identify Oracle-to-PostgreSQL migration risks by analyzing code for behavioral differences (empty strings, refcursors, type coercion, sorting, timestamps, concurrent transactions) when planning or validating database migrations.

Generates a structured integration testing plan for .NET data access layers during Oracle-to-PostgreSQL migrations by analyzing repositories, DAOs, and service layers.

Translate Oracle PL/SQL stored procedures to PostgreSQL PL/pgSQL during database migrations, automatically converting Oracle-specific syntax while preserving method signatures and type-anchored parameters

Generates DB-agnostic xUnit integration tests for .NET data access artifacts during Oracle-to-PostgreSQL migrations, using deterministic seed data to validate behavioral consistency across both database systems.

Design and implement event stores for event-sourced systems with technology comparison, schema design, and best practices for append-only ordered event streams

Manage Linear issues and projects while running PostgreSQL queries and schema operations on Neon, combining project management with database workflows.

Optimize SQL queries with indexing strategies and EXPLAIN analysis to dramatically improve database performance. Use when debugging slow queries or designing schemas.

Scaffold production-ready FastAPI projects with async patterns, dependency injection, and comprehensive error handling for new backend APIs.

Execute database migrations across ORMs (Sequelize, TypeORM, Prisma) with schema transformations, rollback procedures, and zero-downtime deployment strategies

Idiomatic Go patterns and production tooling for the full development lifecycle: coding conventions, concurrency, performance optimization, testing, debugging, CI/CD, database access, GraphQL, gRPC, monitoring, and security auditing.

Optimize PostgreSQL databases by leveraging advanced features: JSONB operations, array types, full-text search, window functions, and performance tuning with EXPLAIN ANALYZE.

Review PostgreSQL code for best practices, anti-patterns, JSONB operations, array usage, custom types, schema design, function optimization, and security features like Row Level Security (RLS).

Generate SQL queries from natural language and perform cohort analysis on user engagement data with retention curves, churn patterns, and statistical A/B testing with ship/extend/stop recommendations.

Scaffolds an xUnit integration test project with transaction-rollback and seed data infrastructure for validating Oracle-to-PostgreSQL database migrations in .NET solutions.

Reviews SQL code for security vulnerabilities, performance issues, and maintainability across MySQL, PostgreSQL, SQL Server, and Oracle databases.

Analyze and optimize SQL query performance, indexing strategies, and execution plans across MySQL, PostgreSQL, SQL Server, and Oracle — tune pagination, batch operations, and pinpoint bottlenecks.

Inventory .NET solution projects and classify them for Oracle-to-PostgreSQL migration eligibility, generating a structured master plan file.

Document behavioral differences between Oracle and PostgreSQL during migration as structured bug reports with severity, root cause, and remediation steps.

Design PostgreSQL schemas with best practices for data types, indexing, constraints, and performance optimization. Covers advanced features for efficient table design.

Master every stage of Supabase project management, from schema design and local development through production deployment, security hardening, performance tuning, and incident response.

Orchestrate 51 specialized AI agents to automate development workflows: code generation and review, quality audits, deployment coordination, research, documentation, and project cleanup across any stack.

Autonomous multi-agent development framework that orchestrates spec-driven sprints: agents plan, implement, test, and review code in parallel across frontend, backend, and CI/CD, converging on a finished feature without manual handoffs.

Analyze SQL queries for performance bottlenecks and automatically rewrite slow queries with execution plan analysis, anti-pattern detection, and database-specific optimizations for PostgreSQL and MySQL

Design and visualize normalized relational database schemas for PostgreSQL and MySQL from requirements, including ERD generation via Mermaid, DDL, constraints, indexes, relationships, and migration scripts.

Query SQL databases and tabular files (CSV, Excel, JSON) using SLQ or native SQL via the sq CLI, with support for cross-source joins, output formatting, and data inspection/diff commands.

Perform fast tabular data wrangling on CSV, TSV, Excel, JSONL, and Parquet files using 55 qsv commands for profiling, cleaning, transforming, converting, joining, validating, and querying data. Includes AI-powered documentation, ontology generation, and performance optimization.

Generate Markdown documentation for PostgreSQL, MySQL, and MongoDB databases by introspecting schemas, including tables, columns, relationships, indexes, constraints, views, procedures, and ERD diagrams.

Generate fullstack project scaffolds with React frontend, Express or FastAPI backend, PostgreSQL database, authentication, Docker, and CI/CD setup. Includes AI agents for API design, database schema, deployment, React expertise, and accessibility.

Analyze PostgreSQL and MySQL index usage to detect missing indexes causing sequential scans, identify unused indexes, and generate SQL scripts for optimal index configuration with impact analysis

Optimize Postgres queries and schema designs with Supabase best practices, manage authentication and RLS, and access Supabase documentation via MCP for any Supabase project.

Manage HubSpot CRM at production scale across multi-portal agencies, including authentication, deduplication, pipeline automation, CRM sync from Salesforce/Pipedrive/Copper, webhook hardening, rate-limit survival, and data warehousing to BigQuery/Snowflake/Postgres.

Track and analyze cryptocurrency portfolios with real-time price data, allocation breakdowns, profit/loss calculations, and risk metrics including Sharpe ratio and VaR. Manage position records with entry prices, stop-losses, and rebalancing recommendations.

Build event-driven APIs with message queues, event streaming, webhooks, and Server-Sent Events, including event schemas, retries, and dead-letter queues for microservices.

Analyze slow database queries across PostgreSQL, MySQL, and MongoDB by interpreting EXPLAIN plans, buffer stats, and index usage to detect bottlenecks like sequential scans, missing indexes, and inefficient joins, and receive specific optimization recommendations with expected impact.

Scan PostgreSQL, MySQL, and MongoDB databases for 50+ security vulnerabilities including weak passwords, excessive permissions, and SQL injection vectors, then generate OWASP compliance reports and automated remediation scripts.

Build and manage Clari revenue intelligence integrations: export forecasts to data warehouses, build analytics, automate pipelines, handle API errors, secure tokens, and monitor changes.

Compare PostgreSQL and MySQL database schemas across environments, detect differences in tables, columns, indexes, constraints, and triggers, and generate safe migration scripts with rollback capabilities.

Archive historical database records to reduce primary table size by 50-90% by moving old data to archive tables or cold storage (S3, Azure Blob, GCS) with automated retention policies, compression, and compliance tracking.

Manage the full lifecycle of Fly.io applications: configure CI/CD with GitHub Actions, deploy Docker containers with health checks, set up Postgres and Redis, troubleshoot deployment issues, optimize performance and costs, and apply security best practices.

Manage large database tables by implementing range, list, hash, and composite partitioning strategies for PostgreSQL and MySQL, with automated partition maintenance and query optimization.

Analyze product data from metrics to execution: build North Star metric trees, explain and optimize SQL, specify dashboards, interpret A/B test results with statistical significance, audit dataset quality, and extract chart data from images.

Integrate with BambooHR API to manage employee data, time-off, benefits, webhooks, and custom reports. Includes authentication, rate limiting, performance optimization, deployment, security, testing, and migration support for production HR data pipelines.

Manage a FairDB PostgreSQL-as-a-Service operation: provision customer databases with role-based access, configure pgBackRest backups to Wasabi S3, run health checks, and follow guided incident response workflows

Provision and manage isolated test environments using Docker Compose and Testcontainers, with lifecycle orchestration, health checks, and support for databases, caches, and queues.

Integrate SerpApi search APIs into Python and Node.js projects with setup, caching, error handling, cost optimization, and production deployment patterns for Google, Bing, YouTube, and Shopping search data.

Accelerate building and operating production LangChain 1.0 and LangGraph 1.0 Python applications with battle-tested patterns for chains, agents, RAG, streaming, HITL, middleware, monitoring, security, and deployment.

Run database tests with fixture loading, automatic transaction rollback, schema validation, and realistic test data generation across PostgreSQL, MySQL, MongoDB, SQLite, and Redis, including ORM support for Prisma, TypeORM, SQLAlchemy, Knex, and Drizzle.

Manage database migrations across PostgreSQL, MySQL, MongoDB, and SQLite with version control, rollback capabilities, and automated schema evolution tracking. Supports migration tools like Prisma, Flyway, Alembic, and Knex for up/down patterns.

Configure and manage database replication topologies with automatic failover, read scaling, and lag monitoring for PostgreSQL, MySQL, and MongoDB.

Manage the full Algolia search lifecycle: configure indexes, sync data from databases, optimize performance and costs, handle errors and rate limits, enforce security and compliance, monitor with Prometheus/Grafana, and deploy to Vercel or Cloud Run.

Manage PostgreSQL and MySQL database backup and recovery workflows with point-in-time recovery via WAL archiving, physical and logical backups, RPO/RTO planning, disaster recovery with automated failover, and backup verification.

Monitor PostgreSQL, MySQL, and MongoDB database health with real-time metrics, predictive alerting, and automated remediation. Detect performance degradation, resource exhaustion, and replication issues before they impact production.

Audit database connections, calculate optimal pool sizes, and configure or deploy PgBouncer/ProxySQL for PostgreSQL and MySQL to prevent connection exhaustion and improve throughput.

Reduce database load by implementing multi-tier caching with Redis, in-memory caches, and CDN layers using cache-aside patterns, TTLs, and invalidation strategies.

Detect, analyze, and prevent database deadlocks across PostgreSQL, MySQL, and MongoDB with lock queries, log parsing, code tracing, and monitoring scripts.

Generate, validate, and deploy stored procedures, functions, and triggers for PostgreSQL, MySQL, and SQL Server databases, automating the creation of production-ready database code with error handling and transactions.

Generate ORM models, migrations, and relationships from database schemas or natural language requirements across Prisma, TypeORM, SQLAlchemy, Django ORM, Drizzle, and more.

Integrate with the MindTickle sales enablement platform: manage training content, quizzes, user progress, and webhooks; set up CI/CD pipelines, local dev servers, and multi-tenant infrastructure; diagnose API errors, enforce security, and optimize costs.

Generate database audit logging implementations for PostgreSQL and MySQL using triggers, application-level logging, or CDC to track changes with before/after values, user identity, and timestamps for compliance monitoring and debugging.

Generate production-ready backup scripts for PostgreSQL, MySQL, MongoDB, and SQLite with scheduling, compression, encryption, and retention policies, plus restore procedures. Automates disaster recovery workflows directly from Claude Code. Supports multiple databases and custom scheduling.

Develop, deploy, and maintain Evernote API integrations, covering OAuth setup, note CRUD, search, webhooks, CI/CD pipelines, multi-environment deployment, monitoring, rate-limit handling, security hardening, and data migration.

Implement backup strategies for databases, filesystems, and cloud resources with automated scheduling, retention policies, encryption, verification, and disaster recovery. Generate production-ready configuration code for multi-platform infrastructure.

Integrate with the Fathom meeting intelligence API to fetch transcripts, summaries, and action items; build analytics pipelines; sync data to CRMs; handle webhooks, rate limits, authentication, and error diagnostics; and deploy containerized services with CI/CD.

Audits PostgreSQL and MySQL databases for data integrity issues (NULLs, orphans, format violations, duplicates) and automatically generates CHECK constraints, foreign keys, and triggers to enforce quality rules across database and application layers.

Manage FairDB PostgreSQL production servers with automated health checks, incident response playbooks, disk space recovery, VPS hardening, PostgreSQL installation and tuning, backup configuration, and compliance auditing

Monitor database transactions across PostgreSQL, MySQL, and MongoDB for long-running queries, lock contention, idle sessions, and anomalies. Automates real-time monitoring with diagnostic queries and alert configurations.

Run integration tests with automated Docker environment setup, database seeding, and cleanup, validating API calls, database queries, and message queue interactions across services.

Designs and implements horizontal database sharding strategies for PostgreSQL, MySQL, and MongoDB, including shard key selection, data distribution analysis, query routing, and rebalancing for massive scale applications.