Firestore vs MySQL
Firestore
cloud.google.com
MySQL
mysql.comSide by side
| Figure | Firestore | MySQL |
|---|---|---|
| Price from | Free | Free |
| Free plan | Yes | Yes |
| Free trial | Yes | Yes |
| Open source | — | — |
| Web | Yes | — |
| Windows | — | Yes |
| macOS | — | Yes |
| Linux | — | Yes |
| iOS | Yes | — |
| Android | Yes | — |
| API | Yes | Yes |
| Self-hosted | — | Yes |
| Plans published | 9 | 18 |
| Spec score · Database Software | 9.2 (#4) | 9.5 (#1) |
| Free plan | Yes | Yes |
| Free tier limits | The free quota applies to one database per project; named databases require billing and do not qualify for the free quota. | The supplied text states platform availability and features but no storage, user, or usage limits. |
| Transactions | Firestore supports ACID-compliant transactions and atomic batch operations. | MySQL is transaction-safe and ACID compliant with commit, rollback, crash recovery and row-level locking. |
Plans
Firestore
- Standard edition — document readsPrice not published
- Standard edition — document writesPrice not published
- Standard edition — document deletesPrice not published
- Standard edition — stored dataPrice not published
- Free quotaFree
- Free quotaFree
- Standard edition pay-as-you-go$0.03 a month
- Enterprise editionPrice not published
- Standard editionPrice not published
MySQL
- Community EditionPrice not published
- Community EditionPriced on request
- Standard EditionPriced on request
- Standard EditionPrice not published
- Enterprise EditionPriced on request
- Enterprise EditionPrice not published
- Cluster Carrier Grade EditionPriced on request
- Cluster Carrier Grade EditionPrice not published
- MySQL Cluster Carrier Grade EditionPriced on request
- MySQL Enterprise EditionPriced on request
In their own words
Firestore
Firestore is a fully managed, serverless document database for building AI, web, and mobile applications. It stores flexible JSON data and supports vector search, full-text search, geospatial queries, and ACID transactions on JSON or BSON-compatible documents. Client SDKs for Android, iOS, and web provide real-time updates and automatic syncing for offline access. Firestore can replicate data across multiple regions with strong consistency; multi-region deployments have a stated 99.999% SLA-backed availability. Integrations named for generative AI application work include Google AI Studio, remote MCP, LangChain, and LlamaIndex. Identity controls connect with Cloud IAM, Cloud Identity Platform, and Firebase Authentication. Data is encrypted before it is written to disk, with customer-managed keys available through Cloud KMS. The free quota applies to one database per project and includes 1 GiB of storage, daily read, write, and delete allowances, and 10 GiB monthly outbound transfer. New customers receive $300 in credits, separate from that quota. Server client libraries bypass Firestore Security Rules, so server access needs IAM controls.