Stay organized with collections
Save and categorize content based on your preferences.
`
AlloyDB AI query engine overview
Run powerful AI models registered through model endpoint management directly within your database using SQL operators. The AlloyDB AI query engine (Preview) integrates with Vertex AI to bring intelligent filtering, semantic ranking, and text generation to your operational data in real time.
Use simple SQL functions for powerful AI tasks. The google_ml_integration extension provides operators like ai.if() (Preview) for intelligent filtering and ai.rank() (Preview) for semantic reranking.
Perform transformations for rows in your database. Using the ai.generate() (Preview) operator, you can ask a foundation model to summarize a product review, or to transform data directly in your query.
Operators call registered model endpoints set up using model endpoint management. Register Vertex AI models like Gemini, or third-party models.
How the AlloyDB AI query engine works
When you embed an AI operator like ai.if(), ai.rank(), or ai.generate() into your SQL query, the AlloyDB AI query engine (Preview) detects it. This engine, available using the google_ml_integration extension, orchestrates the entire process. It securely packages the relevant row data and calls a pre-registered ML model from providers, such as Gemini, OpenAI, or Anthropic. The ML model evaluates the data and returns a prediction—like true/false for a filter or a score for ranking. The AlloyDB AI query engine seamlessly integrates this prediction back into your query's execution, returning a standard SQL result set. You get AI-powered insights without ever moving your data.
Learn more
Explore developer resources to build your own natural language query applications with AlloyDB AI.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-10-22 UTC."],[],[]]
