MCP server: Schema recommendations tool
We've added a new tool to the PlanetScale MCP server: planetscale_list_schema_recommendations.
This tool allows AI agents and MCP-compatible clients like Cursor, Claude, and VS Code to retrieve schema recommendations for your PlanetScale databases. Schema recommendations are automatic suggestions to improve database performance, reduce memory and storage, and optimize your schema based on production database traffic.
With this tool, you can ask your AI assistant to:
- "Show me the schema recommendations for my production database"
- "Are there any unused indexes I should remove?"
- "Check if any of my tables are approaching primary key exhaustion"
We recommend using this tool in the context of the same codebase. Each is a suggestion based on production data and we recommend understanding the pros and cons of each change before implementing. Learn more here.
The tool works with both Vitess and Postgres databases and respects your configured OAuth scopes and permissions.