PostgreSQL plugins

Build production LLM applications with LangGraph agents, RAG pipelines, hybrid search, and advanced prompt engineering. Automate agent architecture design, vector index optimization, and prompt refinement for deploying reliable AI systems.

Transforms Claude Code into a full-stack development assistant with curated expertise across 12 programming languages, major backend and frontend frameworks, DevOps tools, and software engineering practices—enabling code generation, debugging, architecture design, testing, and project management all from a single skill pack.

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.

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.

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 against warehouses like Snowflake, BigQuery, and PostgreSQL, profile tables, and generate interactive HTML dashboards or publication-quality Python charts — all from natural language, then share results via Google Docs or Jira.

Develop production-grade Go applications with AI-assisted skills covering project layout, concurrency, profiling, observability, testing, CI/CD, and idiomatic coding patterns across the full development lifecycle.

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 using SLQ or native SQL, manage database sources, inspect schemas, and diff tables from the command line

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 production .NET backends with Akka.NET actors, Aspire orchestration, EF Core patterns, concurrency primitives, and Kubernetes clustering; run integration tests via TestContainers/Playwright; optimize performance/databases; analyze CRAP scores, benchmarks, and concurrency bugs using 61 skills and 11 agents.

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 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.

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.

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.

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.

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.

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.

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.

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.

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 .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.

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.

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.

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.

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.

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.

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

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

Develop and manage end-to-end Databricks workflows: data engineering with Spark, Delta, Iceberg, and streaming; build and deploy ML models and GenAI agents; create dashboards, apps, and CI/CD bundles; query Unity Catalog and manage infrastructure via SDK/CLI operations.

Battle-tested Claude Code configuration collection delivering 108 components (skills, commands, agents, hooks) for automated code review, test-driven development, security scanning, multi-agent orchestration, and project documentation — evolved over 10+ months of daily use

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.

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.

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.

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.

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.

Run Supabase database operations, automate browser testing with Playwright, and give Claude persistent memory via Upstash for modern web development workflows.

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.

Execute the complete website lifecycle using 102 structured skills covering brand strategy, design systems, accessibility audits, SEO, performance optimization, experimentation, content strategy, and deployment across research, build, and audit phases.

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.

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.

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.

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.

Manage the full data engineering lifecycle: author, test, debug, deploy, and monitor Apache Airflow DAGs; profile and query data warehouses; trace data lineage; migrate Airflow versions; and integrate dbt projects—all from the CLI.

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.

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.

Manage full Firebase projects from Claude: deploy apps to Hosting or App Hosting, build PostgreSQL-backed GraphQL backends with Data Connect, query Firestore databases, implement Authentication, integrate Gemini AI features, configure Remote Config, and audit Firestore security rules.

Manage AWS data lake and analytics workflows: create and manage S3 Tables (Iceberg), import data from databases and S3, query with Athena, manage Glue connections and catalogs, and store/query vector embeddings with S3 Vectors.

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.

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.

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.

Orchestrate multi-session, multi-agent campaigns with persistent state, intent routing, and autonomous quality loops — decompose large work into phases, delegate to sub-agents, and maintain context across sessions.

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.

Manage Aurora DSQL databases: design schemas, execute queries, handle migrations, diagnose query plans, and validate SQL compatibility with IAM auth and multi-tenant patterns. Also query AWS knowledge bases and documentation.

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.

Accelerate full-stack development with an integrated toolkit for architecture planning, test-driven debugging, secure CI/CD, code review, documentation, and automated git workflows and releases.

Develop SAP CAP applications with full lifecycle support: interactive project setup, CDS modeling, service implementation (Node.js/Java), database configuration (HANA/SQLite/PostgreSQL), OData services, deployment to BTP Cloud Foundry/Kyma, and error diagnostics. Includes CDS language server for real-time syntax and navigation.

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.