# Google previews ai.classify and ai.extract SQL functions for AlloyDB AI

> Original title: Introducing new AI functions for AlloyDB: ai.classify and ai.extract

- Source: Google Cloud · AI & Machine Learning
- Published: 2026-11-11T17:00:00.000Z
- Bad Influence: https://badinfluence.news/items/dqhk68xzxqyszhtsuf3n2xhz2
- Original: https://cloud.google.com/blog/products/databases/ai-classify-and-ai-extract-functions-in-alloydb-ai/

## Summary

Google announces the preview of two SQL functions, ai.classify and ai.extract, in AlloyDB AI, available in the google_ml_integration extension version 1.6.1 or later on PostgreSQL 18. ai.classify assigns text to single or multiple user-defined categories, and ai.extract turns unstructured text into JSON matching a target schema. The functions run inside the database with standard SQL, and smart batching groups inputs into micro-batches for queries.