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.