Security and data handling
For your security and procurement teams. Last updated 2026-11-19.
The short version
Rowsmith never collects, sends or stores your query data. When you click Pick rows, it reads the results BigQuery has already loaded into the page (its JSON view), keeps them in the tab's memory, turns the rows you pick into text, and puts that text on your clipboard when you click.
What the extension can access
| Permission | Why |
|---|---|
console.cloud.google.com | The only site Rowsmith runs on. It reads the BigQuery results grid there. |
clipboardWrite | Copies the output you asked for, only when you click. |
storage | Saves your settings and plan status. Never any query data. |
It does not request access to other sites, your tabs, history, cookies, downloads or network traffic, and it holds no Google sign-in or BigQuery access token.
Network calls
The data-handling code makes no network calls; automated checks fail the build if one is added. The only planned call is a license check to our payment provider, which carries your account ID and nothing else.
What is stored, and where
| Data | Stored? |
|---|---|
| Result values, SQL, table and column names, URLs | Never. Held in tab memory only while selected; cleared when the query, page or result changes, after 15 minutes idle, or when the tab closes. |
| Settings (null text, CSV options) | In your browser's extension storage |
| Plan and trial status | In your browser's extension storage |
| "Use anyway" override | In session storage; cleared when the browser closes |
How generated SQL is kept safe
- Every value is encoded as a typed GoogleSQL literal, so quotes, backslashes and newlines can't escape.
- Column names are quoted as identifiers. SQL structure comes only from fixed templates.
- INT64, NUMERIC and BIGNUMERIC values stay exact; they never pass through floating point.
- SQL is never run by Rowsmith. You review it and run it yourself.
- Tested with 20,000+ randomly generated strings per run to prove no value can break out of its literal.
When Google changes the BigQuery page
Before every copy, Rowsmith checks that the grid still looks as expected: headers found, cells line up with columns, values not cut off. Green means all good. Amber means features work but you should double-check the output. Red pauses copying. You can choose "Use anyway (at my own risk)": you then see the exact values before anything is copied, and SQL carries a warning comment.
Isolation
The in-page interface runs in the extension's isolated world inside a closed shadow root. Cell content is only ever rendered as text, never as HTML. No remote code is loaded, and a strict content security policy is set.
An honest limit
Browser extensions run on your computer alongside the page and other extensions. Rowsmith can promise what it does and doesn't do with your data; it can't control other software on your machine, such as clipboard managers.
For administrators
Rowsmith can be force-installed, version-pinned or blocked with Chrome's ExtensionSettings policy.
A ready-to-use policy snippet and a security questionnaire are available on request.
Reporting a vulnerability
Email security@rowsmith.dev. We acknowledge reports within 3 business days and follow a 90-day disclosure window. See security.txt.