PostgreSQL
LiveConnect PostgreSQL to Google Sheets — two-way sync, SQL queries, no ETL needed
Live~10 minutes
MySQL → Google Sheets
Query any MySQL database from Google Sheets — RDS, PlanetScale, or self-hosted.
OAuth 2.0 · Read-only by default · No data stored
~10 minutesSetup time
Username + passwordAuthentication
15 minutesMin sync interval
Read + writeDirection
Capabilities
Everything in the MySQL connector
8 built-in capabilities — from live queries to scheduled syncs and AI-powered data analysis.
Connect to any MySQL instance (RDS, PlanetScale, Aiven, self-hosted)
Run SQL from the Brooked sidebar
Secure SSL connection support
Import query results into sheet ranges
Scheduled syncs for live dashboards
Supports MySQL 5.7+
Technical details
Built for IT teams to approve in one read
Every connection is read-only by default. Credentials are encrypted at rest. Brooked is a verified Google Workspace app.
- Authentication
- Username + password · SSL
- Supported versions
- MySQL 5.7+
- Compatible hosts
- RDS · PlanetScale · Aiven · self-hosted
- Supported objects
- TABLE · VIEW
- Write operations
- INSERT · UPDATE · UPSERT (ON DUPLICATE KEY) · DELETE
- Min sync interval
- 15 minutes
- Row limit
- 10M rows per import (Pro tier)
- Data residency
- Read-only by default
Setup guide
Connect in 3 steps
From install to your first live query in under 5 minutes. No engineering help required.
1
Install the extension
Add Brooked from the Google Workspace Marketplace.
2
Connect your database
Enter your host, port, database, username, and password.
3
Run a query
Write SQL in the sidebar and import results into your sheet.
Need help? Visit support →
Full step-by-step guide
How to Connect MySQL to Google Sheets
Apps Script with JDBC, CSV exports, IMPORTDATA, and no-code add-ons compared — with the exact cloud-provider connection strings (RDS, PlanetScale, Cloud SQL, Azure), scheduled refresh, two-way write-back, and an AI agent that writes the SQL for you.
Read the full guideUse cases
How teams use MySQL + Brooked
From finance reporting to real-time operations dashboards — see what your team can build.
App reporting
Query your MySQL production database for user or usage data and import it into Sheets for weekly reporting.
Live in Google Sheets
MySQL → Sheets · auto-refresh
Available functions
Query MySQL from a cell
Five built-in sheet functions — from natural-language queries to raw SQL and AI-powered KPI cells. No coding required.
fx
=BRKD_QUERY("MySQL", "tables with the most rows in the public schema")
Ask a natural-language question against any connected data source. Returns a table of results that spills into adjacent cells.
=BRKD_QUERY("MySQL", "tables with the most rows in the public schema")
Also supported
More Database integrations
SQL Server
LiveConnect SQL Server to Google Sheets — two-way sync, T-SQL queries, auto-refresh
Supabase
LiveConnect Supabase to Google Sheets — query your Postgres database and sync data without code
Get your spreadsheet hours back
Brooked sets up in seconds. Your team is querying live data before lunch.
Get started free
