惯性聚合 高效追踪和阅读你感兴趣的博客、新闻、科技资讯
阅读原文 在惯性聚合中打开

推荐订阅源

The GitHub Blog
The GitHub Blog
S
SegmentFault 最新的问题
MyScale Blog
MyScale Blog
有赞技术团队
有赞技术团队
V
Visual Studio Blog
T
The Blog of Author Tim Ferriss
爱范儿
爱范儿
Vercel News
Vercel News
让小产品的独立变现更简单 - ezindie.com
让小产品的独立变现更简单 - ezindie.com
Y
Y Combinator Blog
Blog — PlanetScale
Blog — PlanetScale
D
DataBreaches.Net
美团技术团队
Microsoft Security Blog
Microsoft Security Blog
大猫的无限游戏
大猫的无限游戏
Cyber Security Advisories - MS-ISAC
Cyber Security Advisories - MS-ISAC
酷 壳 – CoolShell
酷 壳 – CoolShell
GbyAI
GbyAI
A
About on SuperTechFans
云风的 BLOG
云风的 BLOG
The Cloudflare Blog
宝玉的分享
宝玉的分享
V
V2EX
Microsoft Azure Blog
Microsoft Azure Blog

Blog — PlanetScale

Keeping a Postgres queue healthy — PlanetScale Patterns for Postgres Traffic Control — PlanetScale Graceful degradation in Postgres — PlanetScale High memory usage in Postgres is good, actually — PlanetScale Stripe Projects partnership: Provision PlanetScale Postgres and MySQL databases from the Stripe CLI — PlanetScale Enhanced tagging in Postgres Query Insights — PlanetScale Behind the scenes: How Database Traffic Control works — PlanetScale Introducing Database Traffic Control — PlanetScale Scaling Postgres connections with PgBouncer — PlanetScale Drizzle joins PlanetScale — PlanetScale Video Conferencing with Postgres — PlanetScale Faster PlanetScale Postgres connections with Cloudflare Hyperdrive — PlanetScale Database Transactions — PlanetScale Automating our changelog with Cursor commands — PlanetScale Postgres 18 is now available — PlanetScale Using MotherDuck with PlanetScale — PlanetScale $50 PlanetScale Metal is GA for Postgres — PlanetScale AI-Powered Postgres index suggestions — PlanetScale $5 PlanetScale is live — PlanetScale Announcing Vitess 23 — PlanetScale $50 PlanetScale Metal — PlanetScale Report on our investigation of the 2025-10-20 incident in AWS us-east-1 — PlanetScale $5 PlanetScale — PlanetScale Benchmarking Postgres 17 vs 18 — PlanetScale Larger than RAM Vector Indexes for Relational Databases — PlanetScale Partnering with Cloudflare to bring you the fastest globally distributed applications — PlanetScale Processes and Threads — PlanetScale PlanetScale for Postgres is now GA — PlanetScale Postgres High Availability with CDC — PlanetScale Announcing Neki — PlanetScale
Introducing the PlanetScale MCP server — PlanetScale
Mike Coutermarsh · 2026-01-29 · via Blog — PlanetScale

Mike Coutermarsh |

Today we're releasing the new PlanetScale MCP server, bringing your database directly into your AI tools. With the Model Context Protocol (MCP), Claude, Cursor, Open Code, and other AI tools can now connect to the PlanetScale API to help you improve and better understand your database.

What is the PlanetScale MCP server?

The PlanetScale MCP server is a hosted MCP server that exposes your PlanetScale organizations, databases, branches, schema, and Insights data to MCP-compatible tools. It's authenticated via OAuth for configurable access to permissions and scopes, and accessible from any client that supports MCP servers.

Configurable access

You have full control over which databases the MCP server is able to connect to and access with configurable read-only or full-access permissions which can be set for both production and development database branches.

We advise caution when giving LLMs write access to any production database. Always carefully review queries before execution.

The MCP server exposes the following tools:

  • get_insights — Access query performance data and patterns from PlanetScale Insights
  • list_organizations / get_organization — List and inspect your PlanetScale organizations
  • list_databases / get_database — List and inspect databases within an organization
  • list_branches / get_branch / get_branch_schema — List and inspect database branches and their schemas
  • list_regions_for_organization — List the regions available for an organization
  • list_cluster_size_skus — List available cluster sizes for an organization (filter by engine, include rates, or specify a region)
  • search_documentation — Search across PlanetScale for documentation, code examples, API references, and guides

Available if granted permission:

  • execute_read_query — Run read queries (automatically routed to replicas when available)
  • execute_write_query — Run write queries with built-in safety checks
  • list_invoices / get_invoice_line_items — View billing and invoice details

We will be actively adding to this list of tools. Please let us know how you're using the MCP and what additional data would be useful to you.

Safe and intelligent query execution

Our MCP server includes built-in safeguards and optimizations for running queries:

  • Automatic replica routing — Read-only queries are automatically run against a replica if your database has replicas configured.
  • Ephemeral credentials — Each query uses short-lived credentials that are created on demand and deleted immediately after execution.
  • Built-in query tracking — All queries include source=planetscale-mcp SQL comments, making them easy to identify by tags in PlanetScale Insights.
  • Destructive query protectionUPDATE or DELETE statements without a WHERE clause are blocked, and TRUNCATE is not allowed.
  • Human confirmation for DDL — Any schema-changing operations (CREATE, DROP, ALTER, etc.) prompt the LLM to request human confirmation before proceeding.

PlanetScale MCP use cases

The MCP server gives your AI tools direct access to your database metadata, query patterns, and performance metrics. Here's how you can use it:

Optimize your database schema and queries

Use our MCP server to analyze your database structure, identify bottlenecks, and suggest schema improvements. Ask questions like "Why is this query slow?" or "How should I index this table?" and get answers based on your actual database schema and query patterns.

Use natural language to learn about your data

Pull metrics like daily signups, active users, or conversion rates without writing SQL. Read-only queries are automatically routed to a replica. Get instant insights into how your product is performing and identify trends early.

Debug with full context

Our MCP server has direct access to your schema, indexes, and query patterns. Combining this production context with your codebase gives the LLM the data it needs to find problems and suggest fixes.

Get started

The PlanetScale MCP server is available now. Check out the setup guide to connect your AI tools to your database in minutes.