PlanetScale

planetscale_list_regions_for_organization

List the regions available for an organization.

planetscale_get_invoice_line_items

Get all line items for an invoice. See prorated costs broken down by database branch. Including storage, egress bandwidth and development branches.

planetscale_list_invoices

List all invoices for an organization.

planetscale_list_schema_recommendations

List all schema recommendations for a database. Each schema recommendation is based on production data from the users database. If you have access to the code base generating the queries, evaluate the code in the context of the recommendation to determine the best steps forward for the specific application. Use schema recommendations as a data point for improvement, not a directive. Suggestions include adding indexes, removing redundant indexes, preventing primary key exhaustion, unused tables and other general performance improvements. See https://planetscale.com/docs/postgres/monitoring/schema-recommendations for a full list as well as warnings of possible risks when making schema changes. Set state to "open" to retrieve only open recommendations.

planetscale_get_branch_schema

Get the schema (tables, columns) for a database branch

planetscale_list_branches

List all branches within a databases

planetscale_get_organization

Get details about a specific organization

planetscale_list_databases

List all databases within an organization

planetscale_get_branch

Get details about a database branch

planetscale_get_database

Get details about a specific database

planetscale_list_organizations

List all PlanetScale organizations you have access to

planetscale_search_documentation

Search across the PlanetScale knowledge base to find relevant information, code examples, API references, and guides. Use this tool when you need to answer questions about PlanetScale, find specific documentation, understand how features work, or locate implementation details. The search returns contextual content with titles and direct links to the documentation pages.

planetscale_list_cluster_sizes

List available PlanetScale cluster sizes (SKUs) for an organization. PS- sizes use autoscaling network-backed storage; M- sizes use super fast NVMe storage drives. The rate field is for an HA cluster with 2 replicas; replica_rate is for a single instance. Single instance databases are only available for Postgres. Metal instances must be HA.

planetscale_get_insights

Get query performance insights for a PlanetScale database branch. By default, aggregates the top queries across 5 different metrics (slowest, most time-consuming, most rows read, most inefficient, most rows affected) for a comprehensive view. Can also fetch queries sorted by a single metric.

planetscale_execute_write_query

Execute a write SQL query (INSERT, UPDATE, DELETE, or DDL) against a PlanetScale database. This tool creates short-lived credentials and executes the query securely. TRUNCATE is blocked. DELETE and UPDATE without WHERE clause are blocked. IMPORTANT: DELETE queries and DDL statements (CREATE, DROP, ALTER, RENAME) require human confirmation - you MUST ask the user for explicit approval before setting confirm_destructive: true. Never set confirm_destructive without first showing the user the exact query and getting their explicit 'yes' or approval.

planetscale_execute_read_query

Execute a read-only SQL query (SELECT, SHOW, DESCRIBE, EXPLAIN) against a PlanetScale database. This tool creates short-lived credentials and executes the query securely.