Cloud SQL for PostgreSQL

Simplify all aspects of the database journey with AI-powered assistance, helping teams focus on what matters most. Gemini in Cloud SQL, in preview, enables developers, operators, and database administrators to build applications quickly using natural language, and helps manage, optimize, and govern an entire fleet of databases with a single pane of glass.

Cloud SQL automatically ensures your PostgreSQL databases are reliable, secure, and scalable so that your business continues to run without disruption. Cloud SQL automates all your backups, failover, replication, encryption patches, and capacity increases—while ensuring greater than 99.95% availability, anywhere in the world.

Flexible instance shapes, scale compute, storage, memory independently to better fit your workload needs as they evolve over time.

Easily scale up as your data grows—add up to 96 processor cores, 624 GB of RAM, and 60 TB of storage. Add read replicas to handle increasing read traffic. Automatic storage increases eliminate the need to estimating future storage needs or spending money on capacity before you need it.

Automate daily backups and binary logging to restore your instance to its state at an earlier point in time. Retain your backups for up to one year.

Ensure data reliability at all times. Use high availability to recover from an incident with zero data loss. Automated backups and point-in-time recovery guard against user error. Use cross-region replicas and global VPCs to simplify protecting your data in the event of a disaster.

Simplified secure access with IAM authentication and Cloud SQL Proxy. Data is always encrypted: over Google's networks, and when stored in database tables, temporary files, and backups, with optional support for customer managed encryption keys (CMEK). Connectivity controls with Virtual Private Cloud (VPC) and integrated firewall. Audit logging tracks who did what when.

Cross region replicas provide data residency controls. Access Transparency captures all actions on your instances by Google Cloud personnel. Compliant with SSAE 16, ISO 27001, PCI DSS, HIPAA, and other local regulations.

Cloud SQL for PostgreSQL supports two search approaches for balancing speed and accuracy. Approximate nearest neighbor (ANN) vector search is ideal for large datasets where close matches suffice, while exact k-nearest neighbor (KNN) vector search is used for precision. Integrate vector search directly into your existing database for real-time search context without learning a separate system.

Easily build gen AI applications that are more accurate, transparent, and reliable with LangChain integration. Cloud SQL has three LangChain integrations - Document loader for loading and storing information from documents, Vector stores for enabling semantic search, and Chat Messages Memory for enabling chains to recall previous conversations. Visit the GitHub repository to learn more.