BSON Studio - for MongoDB

StephenTaylor.com

In-app purchases

About this app

BSON Studio is an on-device workbench for MongoDB databases — import a data dump, then browse, query, aggregate, and visualize your collections right on your Android tablet or phone. No server to stand up, no account to create, and nothing leaves your device unless you choose to connect out.

Whether you're debugging a production export on the train, exploring a dataset offline, or learning how aggregation pipelines work, BSON Studio turns a raw BSON or JSON dump into an interactive, queryable database in seconds.

── WORKS OFFLINE. STAYS PRIVATE. ──
• The core runs fully offline — import, browse, find, aggregation, and on-device natural-language queries need no network.
• Your data is encrypted at rest (SQLCipher, AES-256) and never sent to us. BSON Studio has no servers and collects no analytics or telemetry.
• Connection strings and API keys are sealed in the Android Keystore.

── IMPORT ANYTHING ──
• mongodump archives: .bson, --archive, and gzip variants
• JSON, JSONL / NDJSON, and JSON arrays (Extended JSON supported)
• CSV / TSV
• One-tap sample data to explore instantly

── BROWSE & QUERY ──
• Full MongoDB find: filters, projections, sorts, and limits
• Real MongoDB Query Language (MQL) — types are respected, not just matched as strings
• A document viewer built for real BSON types: ObjectId, dates, Decimal128, nested documents, and arrays
• A streaming query engine that stays responsive on large collections

── AGGREGATE & ANALYZE ──
• Build aggregation pipelines stage by stage on a visual canvas
• $match, $group, $unwind, $lookup, $sort, $facet and more — verified against real MongoDB
• Automatic schema analysis, relationship discovery, and PII detection

── VISUALIZE ──
• Dashboards with charts, geo maps, and entity-relationship (ER) diagrams
• Pin results, arrange tiles, and switch chart types on the fly

── CONNECT LIVE (optional) ──
• Connect to your own MongoDB or Atlas server, browse live, and watch change streams
• Insert, edit, and delete with optimistic concurrency; mark any connection read-only for safety
• Non-TLS connections are flagged so you never send data in the clear by accident

── ASK IN PLAIN ENGLISH ──
• Turn natural language into queries with the built-in, on-device translator — no key, no network
• Or bring your own Anthropic (Claude) or OpenAI (GPT) key for richer phrasing — only field names and types are ever sent, never your document values

── BUILT FOR ANDROID ──
• Tablet-first, large-screen layout with multi-tab collections
• Works great on phones too

── NO ADS. NO TRACKING. ──
No ads, no subscriptions, no accounts, no telemetry — ever.

Perfect for backend and full-stack developers, data engineers, DBAs, analysts, students, and anyone who needs to open, inspect, and query MongoDB data on the go.

────────────
BSON Studio is an independent tool for working with MongoDB databases. MongoDB is a trademark of MongoDB, Inc. BSON Studio is not affiliated with, endorsed by, or sponsored by MongoDB, Inc.

What’s new

- Localization into eight languages
- Tap-a-column-header to sort