← All articles

Studio or Teams? Choose your Rowset

Two real workflows: a local workspace for one person and governed access for an organization.

01 · FIELD GUIDE

Studio: you own the workspace

Studio runs on your computer with no Rowset cloud account. It combines a SQL editor, schema browser, row editing, notebooks, personal history, personal policies, managed transactions and optional row backups. Credentials and workspace data are encrypted locally.

SQL EXAMPLEREAD BEFORE RUNNING
SELECT id, total, status
FROM orders
WHERE customer_id = 1001
ORDER BY id DESC
LIMIT 100;
Explore data in the editor, then keep a useful query in an encrypted notebook.
ROWSET STUDIO / SQL WORKSPACEWORKFLOW VIEW
Database Explorer◉ PostgreSQL◉ MySQL◉ MariaDB▾ orders
Table queryRun selected
SELECT id, total, status
FROM orders
WHERE customer_id = 1001
LIMIT 100;
id
total
status
3001
1299.90
paid
3007
89.90
pending
A compact illustration of the Rowset Studio query workspace.
02 · FIELD GUIDE

Teams: access is shared and governed

Teams is a commercial, self-hosted access layer. It offers user roles, connection permissions, shared policies, approvals, masking, row filters, centralized audit and PostgreSQL, MySQL and SQL Server client gateways.

A common case is allowing analysts to query production data while masking sensitive columns and requiring approval for a risky write. This is a policy and access workflow, not merely a different SQL editor.

ROWSET TEAMS / GOVERNANCEWORKFLOW VIEW
01 / ACCESSRoles and connectionsDecide who can reach production.
02 / CONTROLPolicies and approvalsReview sensitive changes before execution.
03 / VISIBILITYMasking and auditProtect results and retain an activity trail.
Illustration of the Teams governance path.
03 · FIELD GUIDE

Which edition fits?

Choose Studio for a personal local-first IDE and optional post-commit row Restore. Choose Teams when several people need common rules and accountable access to production. Teams costs $10 per user per month for teams of up to five. Larger teams can discuss volume pricing with Rowset. Row backups and Restore are not available on its shared server yet.

ROWSET STUDIO / ACTIVITYWORKFLOW VIEW
StatementsRow backups
UPDATEorders3 rows saved before writeRestore
DELETEcustomers2 rows saved before writeReview script
Condensed illustration of the Activity → Row backups flow.
Ready to work with more confidence? Explore Rowset Studio and Teams