PostgreSQL plugins

Turn Claude Code into a multi-agent engineering platform with 542 skills, 184 commands, and 134 agents for end-to-end feature development, code review, build fixing, testing, security auditing, and deployment across 40+ languages and frameworks.

Build and deploy production-grade LLM applications with LangGraph for agent orchestration, advanced RAG pipelines leveraging vector and hybrid search, prompt engineering patterns, and automated evaluation. Covers embedding model selection, vector index optimization, and multi-agent architectures for document Q&A, chatbots, and semantic search over proprietary data.

Develop and deploy Odoo ERP solutions with custom module scaffolding, ORM operations, security rules, eCommerce and CRM configuration, Docker-based deployment, and performance troubleshooting.

Accelerate LLM application development with production-ready patterns for context window management, RAG pipelines, prompt caching, observability via Langfuse, and agent architectures.

Delegate complex data engineering, ML, and AI workflows to specialized sub-agents that design scalable pipelines, build and optimize models, architect LLM systems, tune databases for performance, and deploy production infrastructure across clouds.

Build and manage end-to-end data analytics workflows: implement A/B testing with statistical rigor, design reliable analytics tracking, create interactive D3.js visualizations, architect scalable database schemas, and optimize SQL for cloud-native databases.

Implement Domain-Driven Design with tactical patterns (aggregates, entities, value objects), CQRS, event sourcing, and saga orchestration. Design bounded contexts, map integration contracts, and build event stores with read models for scalable, event-driven systems.

Extend Claude Code with a dedicated DevOps team for cloud infrastructure lifecycle management—designing, deploying, securing, and operating production systems across AWS, Azure, and GCP using Kubernetes, Terraform, CI/CD, and SRE practices.

Write SQL across data warehouses, profile datasets, and generate interactive dashboards and publication-quality charts. Connect to BigQuery, Amplitude, Hex, and Atlassian for integrated data analysis and reporting.

Enables Claude to write, review, and debug production-ready Go code across the full stack: from project scaffolding and idiomatic design through concurrency, testing, benchmarking, database access, GraphQL/gRPC APIs, observability, CI/CD, security auditing, and dependency management.

Generate SQL queries from natural language descriptions using your database schema for PostgreSQL, MySQL, or BigQuery. Analyze CSV or Excel user data to produce cohort retention heatmaps, engagement trends, churn insights, and research recommendations. Evaluate A/B tests for statistical significance, confidence intervals, lift, and ship/extend/stop decisions with Python-powered reports.

Build, secure, scale, and troubleshoot production Supabase apps using 30 skills for Postgres schemas with RLS, auth/realtime/storage integrations, migrations, performance tuning, CI/CD deployments, cost optimization, monitoring, and incident response.

Create and repair Redpanda Connect pipeline configurations and Bloblang transformation scripts using natural language. Automates component search, config generation, and script debugging with optional sample data validation.

Query SQL databases and tabular files directly from the terminal using sq's SLQ or native SQL, with capabilities to manage data sources, inspect schemas, diff tables, and handle various output formats

Analyze slow SQL queries and receive optimized rewrites, index recommendations, execution plan insights, anti-pattern fixes, and performance estimates for PostgreSQL, MySQL, and SQLite databases.

Design normalized relational database schemas for PostgreSQL and MySQL from natural language requirements. Generate DDL statements, constraints, indexes, relationships, migrations, checklists, and Mermaid ERDs following best practices and normalization guidance.

Generate production-ready Docker Compose YAML files for multi-container applications, configuring services, networks, volumes, health checks, resource limits, dependencies, and environment overrides for dev and prod workflows.

Track crypto portfolios using real-time CoinGecko prices to compute P&L, allocations, risk metrics like Sharpe ratio, volatility, max drawdown, VaR, and correlations. Receive rebalancing recommendations, export data to JSON/CSV, and store positions in PostgreSQL for persistent monitoring and analysis.

Build and test .NET applications with Claude Code using curated skills and agents for modern C# (12+), Akka.NET actors, .NET Aspire orchestration, Playwright/TestContainers/Verify testing, BenchmarkDotNet profiling, EF Core optimization, NuGet/CPM package management, and CI/CD caching.

Automate archiving historical PostgreSQL/MySQL records to archive tables or cloud storage (S3, Azure Blob, GCS) using age/status-based rules, retention policies, compression, and compliance tracking to shrink primary database size and manage cold data.

Analyze PostgreSQL, MySQL, and MongoDB query workloads to detect missing indexes causing sequential scans, identify unused indexes, recommend optimal configurations, estimate performance impacts, and generate SQL scripts for index creation and drops.

Compare PostgreSQL and MySQL schemas across database environments to generate idempotent migration scripts with transaction safety, validation checks, rollback procedures, and detailed diff reports.

Interpret EXPLAIN plans and query metrics from PostgreSQL, MySQL, and MongoDB to detect bottlenecks like sequential scans, missing indexes, and inefficient joins. Receive targeted SQL optimization recommendations with expected performance impacts.

Design and implement partitioning strategies for PostgreSQL and MySQL tables using range, list, hash, and composite methods to handle massive datasets. Automate schema design, maintenance routines, query optimization, and data retention policies for improved performance.

Introspect PostgreSQL, MySQL, SQLite, and MongoDB schemas to generate Markdown documentation and interactive HTML reports with ERD diagrams, relationships, indexes, constraints, views, procedures, and data dictionaries for onboarding, audits, and compliance.

Audit PostgreSQL, MySQL, and MongoDB databases for security risks including misconfigurations, privileges, encryption, network exposure, default credentials, and SQL injection in app code. Run scans for 50+ OWASP vulnerabilities, generate compliance reports, automated remediation scripts, and audit trails from your IDE.

Automate complete operations for FairDB PostgreSQL SaaS on VPS: onboard customers with database/user provisioning, run health checks on resources/backups/connections, configure pgBackRest for Wasabi S3 backups, execute incident response scripts for restarts/corruption checks, and deploy agents for proactive monitoring/optimization.

Generate, validate with error handling and transactions, and deploy production-ready stored procedures, functions, triggers, and custom logic directly to PostgreSQL, MySQL, or SQL Server databases using natural language triggers or commands.

Build and deploy production Documenso e-signature integrations in TypeScript/Node.js apps: create signing workflows and templates via SDK/API, configure webhooks and RBAC, set up CI/CD pipelines and Docker/K8s deployments, add monitoring/observability/security, handle errors/rate limits/migrations, and run local testing/diagnostics.

Build production Evernote API integrations in JavaScript/Node.js apps using guided skills for note CRUD/search/webhooks, OAuth auth, rate limit handling, error debugging, data migration/sync, CI/CD pipelines, Docker/cloud deployments (AWS/GCP/K8s), monitoring/security, and performance optimization.

Scan codebases for SQL injection vulnerabilities by tracing user inputs through code to database queries, identifying unsafe patterns like string concatenation and unparameterized ORM usage in Django, Rails, Express, and Go apps. Get risk reports and mitigation recommendations via skills or direct commands.

Build .NET applications that provision Azure infrastructure (databases, caches, bots), integrate AI services (agents, OpenAI, voice, document intelligence, search), manage events/messaging (Event Grid, Hubs, Service Bus), authenticate via Entra ID, and handle Key Vault cryptography using official SDKs and ARM clients.

Implement event-driven APIs by generating publishers and subscribers that integrate with message brokers, webhooks, and Server-Sent Events, handling retries, dead-letter queues, and event schemas for scalable microservices and distributed systems using Redis, PostgreSQL, MongoDB, and AWS in Node.js or Python.

Provision and manage isolated test environments using Docker Compose and Testcontainers for databases, caches, queues like PostgreSQL, MySQL, Redis, DynamoDB. Generate docker-compose files, env vars, seed data scripts, startup scripts, and cleanup code to enable reliable, reproducible testing without local setup conflicts.

Build, deploy, debug, secure, and scale production full-stack apps on Replit from prototype to enterprise, handling architectures, CI/CD pipelines, PostgreSQL integration, auth, troubleshooting, performance tuning, monitoring, team management, and cost optimization.

Introspect PostgreSQL or MySQL schemas to generate ORM models, migrations, and relations for Prisma, Drizzle, TypeORM, Sequelize, SQLAlchemy, and Django ORM. Reverse-generate database schemas from models supporting JavaScript/TypeScript, Python, C#, Java, Ruby, PHP, and more.

Audit database connections, calculate optimal pool sizes, configure app-level pooling parameters, and deploy PgBouncer or ProxySQL for PostgreSQL and MySQL to prevent exhaustion and boost throughput. Implement best practices with code examples for Node.js, Python, and Java.

Set up real-time monitoring for database transactions in PostgreSQL, MySQL, and MongoDB to detect long-running queries, lock contention, idle sessions, throughput issues, and rollbacks. Generate Python scripts, SQL queries, and alert configs for automated performance alerting via CLI.

Implement backup strategies for databases (PostgreSQL, MySQL, MongoDB), filesystems, and AWS resources using tar, rsync, pg_dump, and S3. Automate scheduling, retention, encryption, verification, and disaster recovery, while generating configs, setup code, and documentation for production DevOps.

Implement multi-tier database caching using Redis for L2 distributed cache, in-memory L1 cache, and CDN layers with cache-aside and write-through patterns, TTLs, and invalidation strategies to reduce database load and boost read performance for PostgreSQL and MySQL setups.

Configure replication topologies, automate failover, monitor lag, resolve conflicts, and scale read replicas for high-availability setups in PostgreSQL, MySQL, and MongoDB databases.

Automate database testing workflows by generating test suites with data factories, transaction wrappers for automatic rollback, schema validation, assertions, cleanup, fixtures, migrations, integrity checks, and performance monitoring across PostgreSQL, MySQL, MongoDB, SQLite, Redis using Prisma, Drizzle, Jest, Pytest.

Audit PostgreSQL and MySQL databases for integrity issues including NULLs, orphans, invalid formats, ranges, and duplicates, then generate and enforce CHECK constraints, foreign keys, and triggers. Extend validation to application level with type checks, regex patterns, foreign key integrity, and custom business rules.

Manage complete database migration workflows: generate timestamped up/down SQL or ORM files, validate schemas, execute migrations, perform rollbacks, and track evolution with version control for PostgreSQL, MySQL, MongoDB, and SQLite using Flyway, Alembic, Prisma, or Knex.

Detect and resolve database deadlocks in PostgreSQL, MySQL, and MongoDB by running lock queries, parsing logs, tracing code, and applying preventive patterns. Generate Python and Node.js monitoring scripts, SQL analyzers, prevention docs, and dashboards for ongoing deadlock management.

Generate automated backup scripts, cron schedules, restore procedures, monitoring setups, and recovery plans for PostgreSQL, MySQL, MongoDB, and SQLite databases, including compression, encryption, and retention policies with AWS support.

Implement horizontal database sharding for PostgreSQL, MySQL, and MongoDB at massive scale. Select shard keys, analyze data distribution, route queries, rebalance shards, and generate router code, migration plans, and monitoring setups using consistent hashing and virtual nodes.

Implement disaster recovery and point-in-time recovery (PITR) workflows for PostgreSQL and MySQL databases using WAL archiving, automated backups to S3 or local storage, failover procedures, RPO/RTO planning, testing runbooks, and multi-cloud support for AWS, GCP, Azure.

Monitor PostgreSQL, MySQL, and MongoDB health via CLI queries for connections, throughput, disk usage, cache ratios, and locks. Configure alerting thresholds, receive predictive alerts with remediation guidance, and deploy Grafana dashboards using Prometheus exporters for real-time oversight.

Implement trigger-based audit logging for PostgreSQL and MySQL databases to track INSERT, UPDATE, and DELETE operations with metadata for compliance, security monitoring, and debugging. Generate SQL trigger templates, CDC strategies, and application-level logging setups.

Integrate Azure SDKs into TypeScript/Node.js apps to build AI-powered services for content moderation, document extraction, translation, voice interaction; manage storage, queues, databases like Cosmos and Postgres; handle authentication, Key Vault secrets, Event Hubs, Service Bus messaging; enable monitoring, real-time Web PubSub, and Playwright testing.

Delegate specialized AI agents to design cost-optimized cloud architectures on AWS/Azure/GCP using Terraform, administer and optimize PostgreSQL/MySQL/MongoDB databases, troubleshoot DevOps outages with logs/metrics analysis, configure CI/CD pipelines with Docker/Kubernetes, and debug networks with nginx/HAProxy.

Bootstrap production-ready fullstack MVPs with React+Vite+Tailwind frontend, Express/FastAPI backend, PostgreSQL+Prisma database, JWT/OAuth authentication, tests, Docker containers, and GitHub Actions CI/CD pipelines from a single command. Delegate to AI agents for designing APIs, database schemas, scalable architectures, UI/UX improvements, and deployment strategies.

Deploy, scale, manage, and optimize full-stack apps on Fly.io: from hello-world launches and GitHub Actions CI/CD to multi-region architectures, Postgres/Redis clusters, performance tuning, cost optimization, security hardening, error diagnosis, and Machines API scripting.

Build, deploy, optimize, secure, and troubleshoot Python pipelines exporting Clari revenue forecasts, quotas, CRM data, and adjustments to Snowflake, BigQuery, or PostgreSQL. Includes CI/CD integration, API debugging, cost/performance tuning, local mocks, schema migrations, rate limit handling, and production checklists.

Build production Navan API integrations for travel bookings, expense management, and data syncing to ERPs/warehouses: automate OAuth auth setup, REST workflows, error debugging, CI/CD deployment, monitoring, security hardening, and webhook handling.

Develop, deploy, and manage Databricks-based data pipelines, ML models, AI agents, and dashboards using code, SQL, and declarative tools for multi-environment workflows.

Apply 28 prioritized best-practice rules for ClickHouse schema design, query optimization, and data ingestion, with companion skills for running ClickHouse SQL in Python, reviewing schemas and queries, writing Node.js client code, troubleshooting performance issues, and setting up local or cloud ClickHouse environments.

Provides an extensive collection of Claude Code configs including agents, skills, hooks, and commands for TDD workflows, code reviews, security audits, database migrations, API design, deployment automation, documentation generation, and multi-model orchestration evolved from real-world daily use

Integrate Fathom AI meeting analytics into apps: authenticate API access, fetch transcripts/summaries/action items, set up webhooks for real-time processing, sync to CRMs like Salesforce/HubSpot, optimize rate limits/performance, secure PII handling, deploy via Cloud Functions/Docker, and test with CI/CD pipelines.

Operate FairDB PostgreSQL VPS instances end-to-end: run daily health checks and monitoring, execute P0 incident response playbooks for outages and disk issues, perform SOP-guided setups for secure servers with backups, and audit compliance using autonomous agents.

Optimize SQL queries and analyze execution plans in plain English for PostgreSQL, MySQL, SQLite, and SQL Server. Identify costs and bottlenecks, get index suggestions and rewrites, then compare before/after performance using EXPLAIN ANALYZE.

Manage AWS data lakes and analytics workflows: create and query Iceberg tables on S3 Tables, run Athena SQL across Glue and Redshift catalogs, ingest data from JDBC databases, Redshift, Snowflake, BigQuery, and DynamoDB, audit Glue Data Catalog assets, and store/query vector embeddings on S3 Vectors for semantic search and RAG.

Accelerate website creation and optimization with 103 structured skills spanning research, brand strategy, design, content, SEO, analytics, performance, security, and deployment—each providing expert-level prompts for tasks like auditing accessibility, fixing Core Web Vitals, conducting competitive analysis, running experiments, and managing incident response.

Perform Five Whys root cause analysis to identify issues and solutions, generate Mermaid ERDs from SQL migrations or database schemas, and follow structured 4-step guides for problem-solving and project building through to deployment.

Design optimized PostgreSQL schemas from business requirements with entity modeling and SQL DDL, generate Node.js migration frameworks with zero-downtime strategies and rollbacks, and optimize performance for PostgreSQL/MySQL by analyzing slow queries, indexes, execution plans, and resource usage.

Enhance Claude Code with 14 productivity commands and 11 specialized AI agents for modern web development, including RAG-powered knowledge retrieval, Supabase database queries and schema management, and Playwright-based browser automation and web testing.

Implement spec-driven development workflow: convert vague ideas to EARS requirements, generate technical design and steering documents, break designs into sequenced tasks with dependencies, apply QA checklists, AI prompting strategies, and troubleshooting for structured, reliable feature delivery.

Run a local GraphJin MCP server to execute instant GraphQL queries against your PostgreSQL database and explore its full schema directly in Claude Code. Point it at your DB via a simple config file, then query data or introspect structure using natural language prompts—no extra setup needed.

Develop full-stack Supabase apps by configuring local environments and managing migrations, edge functions, secrets with CLI and TypeScript codegen; integrating supabase-js SDK for PostgREST queries, auth, storage uploads, realtime subscriptions; optimizing Postgres with best practices for schema design, query performance, connection pooling, RLS security.

Interactively design database schemas from application requirements, defining entities, relationships, indexes, and constraints while generating SQL DDL and text-based ERDs. Create visual Mermaid ERDs (saved to docs/erd.md) from existing schemas, ORM models, migrations, or live databases, with optional DBML output and counts of tables/relationships.

Build Retrieval-Augmented Generation (RAG) pipelines by indexing documents from directories, URLs, databases, or APIs into vector stores like Pinecone, Weaviate, Chroma, or pgvector using semantic chunking and embeddings, then creating retrievers with hybrid search, re-ranking, caching, citations, fallback handling, and evaluation metrics.

Generate realistic test data from schemas or models, respecting constraints, relationships, and locales, then output as JSON, CSV, SQL INSERTs, or fixtures with validation reports. Seed development databases idempotently via transactional scripts that include cleanup and verify inserted counts for Prisma, Django, and SQL databases.

Optimize PostgreSQL and MySQL query performance by running EXPLAIN ANALYZE to identify issues, locks, and patterns, generating structured reports with improvement estimates and suggestions, then applying index recommendations via safe concurrent migrations with redundancy checks.

Automate full-cycle Elixir/Phoenix/LiveView development: use /phx: commands and specialist agents to brainstorm/plan features, implement changes, audit architecture/performance/security, debug bugs/Ecto/Oban issues, review PRs, verify with mix tools/tests, compound solutions into docs, and deploy to Docker/Fly.io.

Launch, control, and debug Polar's Docker local dev environment for FastAPI API, Next.js web app, PostgreSQL, and Redis—start/stop services, tail logs, shell access, status checks. Reference and implement billing workflows: Stripe subscriptions, checkouts, proration, dunning, benefit provisioning in Django backend.

Manage the full Airflow data engineering lifecycle: author, test, debug, and deploy DAGs; profile and trace lineage across warehouses; migrate between Airflow versions; and troubleshoot production deployments via CLI.

Accelerate Java Spring Boot development by generating CRUD apps, REST APIs, and AI integrations with LangChain4j; write unit/integration tests; integrate AWS services like RDS, DynamoDB, S3, Lambda; refactor code, audit security/dependencies, and produce documentation/architecture reviews via agents, commands, skills, and LSP support.

Manage entire project lifecycles from within Claude Code: save and resume session context, plan and track tasks, run security scans, generate documentation, deploy apps, and automate business workflows — all through markdown-based skills triggered by natural language commands.

Provides 59 expert skills covering the full SaaS lifecycle for non-technical founders building with AI tools: planning, design, build, database, integrations, AI features, security, testing, debugging, deployment, monitoring, marketing, pricing, growth, and business strategy.

Manage Firebase projects from Claude: deploy apps and backends, configure Firestore and authentication, run SQL queries, set up AI features with Gemini, and audit security rules — all through Firebase CLI

Build product metrics frameworks with North Star metrics, KPI trees, and counter-metrics; explain, optimize, and generate SQL queries for PostgreSQL, MySQL, SQLite; create structured dashboard specs including KPIs, charts, and layouts from business questions for BI tools like Looker or Grafana.

Build and test dbt models using SQL transformations, ref/source, and YAML unit tests; configure semantic layers for metrics, dimensions, and KPI queries; troubleshoot Cloud jobs with logs, API, and git; implement Mesh governance for contracts and cross-project refs; access docs; format CLI commands; generate MCP configs for VS Code integration.

Build, deploy, and manage Vercel projects including Next.js apps, AI features with the AI SDK, serverless functions, microfrontends, monorepos, and marketplace integrations. Automate CI/CD pipelines, configure environment variables, manage storage and authentication, and optimize performance and security

Manage Amazon Aurora DSQL databases: design schemas, execute queries, handle migrations, analyze query plans, configure IAM auth, and load bulk data. Also query AWS knowledge bases for documentation and best practices.

Optimize PostgreSQL, MySQL, MongoDB, and Redis performance for enterprise B2B SaaS and multi-tenant platforms by tuning queries, designing indexing strategies, configuring connection pooling, implementing scaling solutions, and setting up monitoring workflows.

Profile PySpark DataFrames or Unity Catalog tables with AI to generate data quality rule candidates, define rules via Python classes or YAML, validate against DQEngine, run end-to-end checks splitting valid/quarantined rows, and persist rules to Delta tables, volumes, or Lakebase.

Generate production-ready AWS CloudFormation templates for VPCs, EC2, ECS, RDS, DynamoDB, Lambda, S3, CloudFront, ElastiCache, Bedrock, and security groups; deploy ECS services via GitHub Actions CI/CD; bootstrap SAM projects; create Draw.io architecture diagrams; automate AWS CLI workflows; optimize costs; and review designs with expert agents.

Automate X/Twitter fully without API keys: scrape profiles/tweets/followers/media, post threads/polls/DMs, manage lists/follows/blocks/mutes, analyze engagement/trends/networks/competitors, monitor growth/monetization, and build AI agents via Puppeteer browser scripts, CLI, REST APIs, and 80+ MCP tools.

Enforce idiomatic Elixir and Phoenix LiveView best practices across code quality, Ecto schemas and changesets, OTP behaviors, authentication flows, security rules, deployment configs, PubSub patterns, file uploads, Oban jobs, telemetry, and testing via targeted skills for analysis and refactoring, plus agents for project structure, Ecto conventions, LiveView checklists, and testing guides.

Orchestrate a full AI engineering team of 12 specialized agents in Claude Code to handle complete software dev lifecycles: delegate planning, fullstack feature builds, UI design, refactoring, migrations, code reviews, security verification, debugging, DB analysis, onboarding, tooling, and research, backed by 15 automation hooks for pre-commit checks, branch protection, secret scanning, and quality enforcement via P7/P9/P10 methodologies.

Optimize database performance for enterprise B2B SaaS and multi-tenant platforms by tuning queries, implementing indexing strategies, connection pooling, scaling, and monitoring setups tailored for PostgreSQL, MySQL, MongoDB, and Redis.

Sync a production PostgreSQL database from AWS to a local Django development environment, restoring it with migrations and an admin user

Optimize PostgreSQL, MySQL, MongoDB, and Redis performance for enterprise B2B SaaS and multi-tenant platforms by tuning queries, implementing indexing strategies, configuring connection pooling, and planning scaling with monitoring.

Guides SAP Cloud Application Programming Model development using Capire documentation for CDS model design, service implementation, database configuration (SAP HANA, SQLite, PostgreSQL), Node.js and Java runtimes, Fiori UI integration, deployment to BTP Cloud Foundry and Kyma, and authorization/multitenancy setup.

Run 100+ specialized AI commands, skills, and agents via /spartan to scaffold Kotlin Micronaut backends and Next.js apps, provision Terraform AWS infra, automate PR reviews/gates/tests/QA, manage startup pipelines from idea validation to investor pitches, with safety locks, multi-agent coordination, and deep codebase analysis.