databases

Explore your warehouse, inspect tables, and sample rows without leaving the editor. The extension connects to Snowflake, BigQuery, Redshift, and Postgres instances, pulls schemas, reads column statistics, and runs profiling queries so you can spot skews, nulls, and cardinality issues. It generates ready-to-run SQL snippets, maps schema changes to downstream models, and records table lineage as you edit transformations. This plugin exposes over 30 focused skills and an MCP server that talks to Apache Airflow's full REST API. You can create and edit DAGs, push DAG files, trigger runs, check task status, read task logs, clear failed tasks, and watch scheduler health. It edits dbt models, runs dbt commands, writes tests, and commits changes with clear git messages. The tool also helps write pipeline code: it scaffolds Python or SQL transformation functions, generates parametrized operators, and creates sensible defaults for retries, timeouts, and task dependencies. It tracks schema drift by comparing current table metadata to expected models and flags breaking changes so you can add tests or migrations. Imagine fixing a failing Airflow task: you inspect the table samples, write a quick SQL patch, update the DAG, push the change, and trigger a backfill — all from the same interface. That avoids context-switching between console, SQL editor, git, and Airflow UI, saving hours when debugging production pipelines or shipping hotfixes.

PlanetScale gives Claude live, authenticated access to your PlanetScale accounts so you can browse organizations, databases, and branches without leaving your editor or chat. You can list branches, inspect branch status, and fetch connection details. It maps your schema objects—tables, columns, indexes—so you can ask specific questions about structure and relationships. Run SQL queries against a selected branch and return results as JSON or tabular text. The plugin reads query execution info and pulls Insights metrics so you can check slow queries, error rates, and query distribution. It also exposes account and organization metadata so you can verify permissions and billing context while debugging. The tool supports interactive workflows: run a query, review results, then request a follow-up optimization that references exact slow queries from Insights. It lets you switch branches, re-run tests, and compare schemas across branches without copying connection strings or hopping into a separate console. For example, when a staging endpoint shows errors you can inspect the failing query, pull the Insight that highlights its latency, and try an optimized query all inside Claude. That saves time and prevents context switching between your chat, a SQL client, and the PlanetScale console during an incident response or schema review.

Data connects Claude Code to your databases and CSVs and helps you explore tables, sample rows, and schema. It reads data sources, inspects column types, and lists foreign keys and indexes so you quickly understand structure before you write queries. It writes SQL queries you can run against PostgreSQL, MySQL, SQLite, and common cloud warehouses, and adjusts syntax across dialects. It can generate JOINs, aggregations, window functions, and parameterized queries, and it explains why a query returns certain rows. It generates charts and dashboards from query results: line, bar, scatter, histogram, and pivot tables. It maps columns to axes, sets labels and colors, and exports PNG or interactive embeds. You can iterate on visualizations without exporting CSVs or hand-editing code. In a real workflow, you can ask for a retention curve, get the SQL, run it, tweak the chart, and save a dashboard — all inside Claude Code. That avoids switching to a separate BI tool just to explore a table, build a chart, and share a result with teammates.

Connect Claude directly to MongoDB databases to query collections, analyze data, and manage database operations through natural language. This MCP server plugin enables seamless exploration of your MongoDB data and automated database tasks within your coding workflow.

Connects to your Prisma-managed Postgres database and gives you a conversational interface to run migrations, inspect schemas, and execute SQL. You can ask Claude to generate a Prisma migration file from a schema diff, show the SQL it will run, and apply or rollback migrations. It also reads migration history and shows which migrations are applied vs pending. Runs queries you type or ones Claude generates from natural language, returning rows or summaries. It can introspect the current DB schema, map tables to Prisma models, and produce model definitions you can copy into schema.prisma. It supports running queries inside transactions and offers dry-run SQL so you can review destructive changes before applying them. Connects to cloud Postgres instances or local dev databases via your connection string. You can spin up ephemeral instances for testing, seed data, and then tear them down. It watches for schema drift and can suggest migration steps to reconcile Prisma models with the live database. Works well when you're fixing a bug or adding a feature and want to avoid switching to a GUI: ask for the schema diff, get the migration SQL, review results, and apply it all from Claude while also running test queries — saves time compared to jumping between an ORM, psql, and a database GUI.

Pinecone connects Claude Code to your Pinecone vector database so you can create, inspect, and modify indexes without leaving the editor. It lists available indexes, reads index metadata, creates and deletes indexes, and uploads (upserts) or deletes vectors. You can fetch vectors by id, run similarity queries with text or precomputed vectors, and retrieve raw match scores and metadata for each hit. The plugin sends queries in plain language or vector form, maps query results back to your data, and returns the original payloads and namespace info. It supports batching for bulk upserts, paginated fetches for large result sets, and optional score thresholds to filter matches. You can watch operations and get status responses for long-running jobs. Use it when you want to prototype a semantic search feature, iterate on index schemas, or debug retrieval quality without switching to another console. For example, while building a customer support search you can upsert transcripts, run natural-language queries, inspect top matches and adjust namespaces or metadata on the spot — saving the time of toggling between Claude Code and the Pinecone dashboard.

Full Firebase access from the terminal. This plugin connects Claude Code to your Firebase projects so you can list projects, switch targets, and set environment variables without opening the Firebase console. It reads project metadata and shows active configs. You can read and write Firestore documents, run queries, and batch updates. It manages Authentication users (create, delete, list, update claims), uploads and downloads Storage files, and manipulates Realtime Database entries. It also reads logs and shows function invocation details. Deploy and rollback Cloud Functions, publish hosting sites, run the local Emulator Suite, and run CI-style test deploys. It reads and edits firebase.json, sets hosting rewrites, updates Firestore rules, and runs rules simulators. The plugin calls the Firebase CLI under the hood and streams command output back to Claude Code. In a typical workflow you can inspect a failing function log, patch code, deploy the new function, and run an emulator-triggered test without switching to a browser or separate terminal — useful when you want to fix a production bug while staying inside your IDE and avoiding context switching.

Connect Claude directly to your Supabase backend and run SQL, manage auth rules, configure storage buckets, inspect real-time subscriptions, and read project logs without opening the dashboard. You can run queries, list tables, inspect schemas, and apply migrations from the conversation. The integration exposes over 20 tools that map to common supabase-cli and dashboard actions so you can keep working in one place. It reads and writes database rows, creates and deletes storage objects, sets and revokes role policies, and updates environment variables. You can create or rollback migrations, generate REST endpoints, check replication status, and pull usage metrics. The plugin watches realtime channels and reports emitted events so you can debug live behavior. Use it to inspect auth flows, validate RLS policies against sample requests, and tail function logs. It shows query plans, returns execution errors, and lets you restart services or trigger backups. One sentence: this plugin sends commands to your Supabase project and returns structured responses you can act on. For example, during a production incident you can run a failing query, read the realtime event stream for a user, patch an RLS policy, and restart a function without opening the dashboard or switching windows—so you finish triage faster and avoid context switching between tools.