Overview
PlanetScale uses generative AI to power two Insights features. This overview explains those features and how PlanetScale ensures safety and privacy of customer data.Which features use generative AI
Two features of Insights use generative AI:- Postgres index recommendations use a large language model to interpret query patterns and identify potential indexes that could improve performance of those patterns. The prompt sent to the LLM includes one or more query patterns and one or more table schemas. Query patterns and table schemas include the names of tables and columns, but not any actual row data. This process runs automatically on each database each night.
- Query summaries for both Postgres and Vitess use a large language model to convert a query pattern to a one-sentence description. The prompt sent to the LLM contains a query pattern. This feature is invoked only when a user clicks on the “Summarize query” button on an Insights query-details page.

