Databases is the most Claude-connected category on GCP
Nearly every managed database has a Google-hosted remote MCP server, so an agent can provision instances, apply schemas, and migrate data via natural language. The same databases are also fronted by the open-source MCP Toolbox for Databases if you'd rather self-host a single endpoint.
Databases
Cloud SQL
Covered
MCP · remote
What it is. Fully managed relational database for MySQL, PostgreSQL, and SQL Server — the default relational choice for most apps.
Reach for it when. You want standard SQL without managing the engine, backups, or patching; your data is relational and fits comfortably on a single primary (with read replicas); or you're migrating an existing MySQL/Postgres/SQL Server app.
Claude / MCP. Google-managed remote MCP servers for all three engines. Also fronted by the OSS MCP Toolbox for Databases.
AlloyDB for PostgreSQL
Covered
MCP · remote
What it is. PostgreSQL-compatible database tuned for demanding enterprise workloads — faster than standard Postgres on mixed transactional/analytical loads, with built-in AI/vector features.
Reach for it when. You've outgrown Cloud SQL Postgres on performance, or you want Postgres compatibility plus heavy analytical queries or vector search in the same database.
Claude / MCP. Google-managed remote MCP server, plus the OSS MCP Toolbox.
Firestore
Covered
MCP · remote
What it is. Serverless NoSQL document database with real-time sync and MongoDB compatibility. Scales automatically; flexible schemas.
Reach for it when. You're building mobile/web apps that need real-time updates and offline sync, your data is document-shaped, and you don't want to manage capacity.
Firestore is covered — the broader Firebase platform is a separate surface
Firestore itself is on the covered list, but the wider Firebase platform (Firebase Auth, Hosting) is a distinct surface. For end-user authentication in a PHI app, use Identity Platform (the enterprise sibling of Firebase Auth, covered in Security & Identity) rather than Firebase Auth.
Claude / MCP. Google-managed remote MCP server, plus the OSS MCP Toolbox.
Spanner
Covered
MCP · remote
What it is. Cloud-native relational database with effectively unlimited horizontal scale and 99.999% availability — globally distributed and strongly consistent. The "Google-scale" relational option.
Reach for it when. You need relational semantics and massive scale / global distribution, you can't accept the single-primary ceiling of Cloud SQL, or financial-grade availability matters.
Claude / MCP. Google-managed remote MCP server, plus the OSS MCP Toolbox.
Bigtable
Covered
MCP · remote
What it is. Cloud-native wide-column NoSQL database for huge-scale, low-latency workloads (the database behind many Google products).
Reach for it when. You have enormous volumes of time-series, IoT, or analytical key-value data; you need single-digit-millisecond reads/writes at scale; and your access pattern is key-based, not relational.
Claude / MCP. Google-managed remote MCP server, plus the OSS MCP Toolbox.
Memorystore
Covered
gcloud CLI
What it is. Fully managed Redis and Memcached for sub-millisecond in-memory data access.
Reach for it when. You need a cache in front of a database, fast session storage, rate limiting, or ephemeral state.
Claude / MCP. Via the gcloud MCP (no dedicated database MCP server).
Datastore
Covered
gcloud CLI
What it is. The older NoSQL document database (Firestore in Datastore mode is the modern path). Still covered and supported.
Reach for it when. You're maintaining an existing Datastore app. For new builds, prefer Firestore.
Claude / MCP. Via the gcloud MCP.
Encrypt PHI before using it as a Datastore index key or value
Datastore index keys and values surface in metadata and query paths. If a property could hold PHI and you intend to index or key on it, encrypt it first so the protected data never appears in plaintext in the index.
Database decision table
| Data shape / need | Recommended database |
| Standard relational, single app | Cloud SQL (MySQL / Postgres / SQL Server) |
| Postgres, but need more performance / vector / analytics | AlloyDB for PostgreSQL |
| Relational at global scale, strong consistency | Spanner |
| Real-time documents, mobile/web, flexible schema | Firestore |
| Massive key-value / time-series at low latency | Bigtable |
| Cache / in-memory / ephemeral state | Memorystore (Redis / Memcached) |
| Maintaining an existing NoSQL app | Datastore (new builds → Firestore) |
One MCP endpoint for many databases
The open-source MCP Toolbox for Databases (googleapis/genai-toolbox) is a single self-hosted MCP server that fronts BigQuery, Cloud SQL, AlloyDB, Spanner, Firestore, and more. Use it when you want one endpoint covering several databases instead of wiring each remote server separately.
Creating a PHI-safe Cloud SQL instance
A PHI database should have no public IP, require SSL, keep automated backups, and be reachable only over Private IP / Private Service Connect — never the public internet.
gcloud sql instances create phi-pg-01 \
--database-version=POSTGRES_15 \
--region=us-central1 \
--tier=db-custom-2-7680 \
--no-assign-ip \
--network=projects/PROJECT_ID/global/networks/phi-vpc \
--enable-google-private-path \
--ssl-mode=ENCRYPTED_ONLY \
--require-ssl \
--backup \
--backup-start-time=03:00 \
--retained-backups-count=30 \
--availability-type=REGIONAL
--no-assign-ip — Private IP only; the instance is never given a public address.
--network / --enable-google-private-path — reachable only from inside your VPC.
--ssl-mode=ENCRYPTED_ONLY / --require-ssl — reject unencrypted connections.
--backup / --retained-backups-count — automated, retained backups for recovery.
--availability-type=REGIONAL — high-availability failover across zones.
Connect over Private IP / Private Service Connect — including for migrations
Always reach a PHI database over Private IP or Private Service Connect so it's never exposed to the internet. This applies doubly to Database Migration Service: configure it for Private IP connectivity so PHI never traverses a public path during a migration. Layer CMEK (Cloud KMS) on the instance when your compliance posture requires holding your own keys.
Storage
Cloud Storage
Covered
MCP · OSS
What it is. Object storage — secure, durable, scalable buckets for files of any kind. The default home for uploaded documents, medical images, data exports, ML training data, and long-term audit-log archives.
Reach for it when. You need to store and serve files (uploads, reports, images, exports), stage data for BigQuery or ML pipelines, or archive audit logs for long-term retention.
Two standing recommendations. Enable Object Versioning to recover from accidental deletion, and never request caching of PHI via Cloud CDN — CDN caches are not a place for protected data.
Claude / MCP. Open-source Cloud Storage MCP server (googleapis/gcloud-mcp) — read/write objects and provide buckets as agent context for unstructured data.
Filestore
Covered
gcloud CLI
What it is. Managed, scalable network file storage (NFS) that VMs and GKE clusters can mount like a shared drive.
Reach for it when. An application expects a POSIX file system / shared mount, or your GKE / Compute Engine workloads need shared file access. Use IP-based access control to restrict which clients can mount it, and enable backups.
Persistent Disk
Covered
gcloud CLI
What it is. Block storage attached to Compute Engine VMs — the durable disks behind your instances, surviving restarts.
NetApp Volumes
Covered
gcloud CLI
What it is. Managed file storage for NFS, SMB, and multi-protocol environments — enterprise NAS in the cloud, for migrating workloads that need SMB or multi-protocol shares.
Backup and DR Service
Covered
gcloud CLI
What it is. Centralized, application-consistent backup and disaster recovery across your GCP resources. For PHI, a managed backup/restore and DR strategy is not optional.
Storage Transfer Service / Transfer Appliance
Covered
gcloud CLI
What it is. Move large volumes of data into Cloud Storage — online (Storage Transfer Service) or via shipped hardware (Transfer Appliance) for very large datasets migrating from on-prem or another cloud.
Storage decision table
| Need | Recommended storage |
| Files / blobs / unstructured data, exports, images, log archive | Cloud Storage |
| Shared file-system mount (NFS) for VMs / GKE | Filestore |
| Durable block disk for a VM | Persistent Disk |
| Enterprise SMB / multi-protocol NAS | NetApp Volumes |
| Backup & disaster recovery | Backup and DR Service |
| Bulk data migration in (online / offline) | Storage Transfer Service / Transfer Appliance |
Creating a PHI-safe bucket
Lock the bucket to uniform bucket-level access (IAM only, no per-object ACLs), turn on versioning, and add a lifecycle / retention policy. Layer CMEK when you need key custody.
# Create with uniform access + CMEK at creation time
gcloud storage buckets create gs://phi-app-intake-01 \
--location=us-central1 \
--uniform-bucket-level-access \
--public-access-prevention \
--default-encryption-key=projects/PROJECT_ID/locations/us-central1/keyRings/phi-kr/cryptoKeys/phi-key
# Turn on Object Versioning (recover from accidental deletes)
gcloud storage buckets update gs://phi-app-intake-01 --versioning
# Upload an object — filename only, NEVER PHI in the object name
gcloud storage cp report.pdf gs://phi-app-intake-01/intake/
--uniform-bucket-level-access — access governed solely by IAM, no surprise per-object ACLs.
--public-access-prevention — the bucket can never be made public.
--default-encryption-key — CMEK so you hold the key (default encryption-at-rest is always on; this adds key custody).
- For retention, attach a lifecycle rule (e.g. transition to Archive class, set a retention period for the audit-log archive).
Resource names are metadata — keep PHI out of them
Object names, bucket names, and database instance / table / index names all surface in Cloud Audit Logs, billing exports, and consoles visible to anyone with the right role. Treat them as metadata: never encode patient names, MRNs, or any identifier in them. Encryption-at-rest is on by default for every product here; layer CMEK (Cloud KMS / Cloud HSM) whenever your posture requires holding the keys yourself.