TableCore documentation

TableCore is a desktop MongoDB workspace for people who think in SQL. These pages describe what it does today — including what it refuses to do, and why.

Start here

Install it, connect to a server, run a query, and find out what this release does and does not cover.

InstallationInstall TableCore on Windows, understand the unsigned-installer warning, and find where it keeps your data.Your first connectionThe shortest honest path from a fresh install to a MongoDB server you can query.Your first queryWrite a SELECT, run it, read the result, and read the MongoDB command it became.What this release coversWhat TableCore does, what it deliberately does not do, and why translated SQL is read-only.

Connections

Everything that happens before a query runs — including exactly where your production credentials are kept.

Connection profilesCreate, edit and organise connection profiles, and understand what settings.json holds.Credentials and secretsExactly where TableCore puts your production credentials, per platform, with the key names.SSH tunnelsReaching MongoDB through a bastion: host key verification, what is supported, and how failures are reported.Read-only connectionsWhat a read-only connection blocks, including raw commands, and why it is a guard rather than a permission.

Querying

The core of the product: which SQL is accepted, the MongoDB command it becomes, and how closely the answers match.

SQL supportThe clause-by-clause reference of what the engine accepts and refuses, with its measured agreement with SQL.SQL to MongoDBThe MongoDB command each SQL shape becomes, from the engine's own golden fixtures.MongoDB shell syntaxRunning db.collection.find(...) and friends, and when to prefer shell over SQL.Explain plansReading the server's plan, spotting a collection scan, and knowing which queries can be explained.Query as codeExporting a query as mongosh, C# driver or C# LINQ code, and what you still have to supply.Query historyWhat TableCore records about every query you run, for how long, and how to turn it off.Saved queriesThe deliberate query library: folders, portability between connections, import and export.

Working with data

What you do with a collection once you can see it — documents, schema, indexes, files and reshaping.

Browsing and editing documentsThe type-aware grid, when a result is editable, and what happens when you save.Schema explorerInferring a collection's shape from a sample, and reading the numbers as the sample they are.Validation rulesReading and proposing JSON Schema validation for a collection, and counting violations first.IndexesCreating, editing and dropping indexes, and reading index usage statistics.Exporting resultsWriting a whole query result to BSON, JSON or CSV, and what a large result costs.GridFSBrowsing, downloading and uploading files stored in a GridFS bucket.Reshaping collectionsRenaming a field everywhere or extracting an array — what can be lost, and how to run it safely.Safe modeKeep a restorable copy of every document TableCore overwrites, and get one back.

Backups and migration

The features you reach for when something has already gone wrong, which is the worst time to find nothing written.

BackupsWhat a TableCore backup contains, why mongorestore can read it, and what it costs.Restoring a backupRestoring into the same or a different database, and how to verify a restore actually worked.Transferring dataCopying a database to another connection, exporting it to files, and importing those files back.Migrating from SQLMoving a relational database into MongoDB: the mapping model, the transfer, and the verification step.

Server monitoring

Live metrics, current operations, replica sets, the profiler and sharded clusters.

Server metricsThe live metrics panel, what it costs your server, and how to read saturation before throughput.Current operationsReading what the server is doing now, and what killOp can and cannot stop.Replica sets and the oplogMember states, replication lag with its basis, and what a shrinking oplog window is warning about.Database profilerThe slow-operation log grouped by query shape — what it costs, and how to turn it off again.Sharded clustersBalancer state, data distribution, and what makes an imbalance permanent.

Account and licensing

Passwordless sign-in, which six operations require Pro, and what happens when the application is offline.

Accounts and sign-inPasswordless accounts, the desktop approval flow, the one-time code every platform has, and how to erase the account.Plans and Pro featuresWho may license Free, which six operations require Pro, what every account has, and where entitlements come from.Offline and entitlementsHow TableCore knows what you are entitled to without a network, and what degrading to Free means.UpdatesHow updates are delivered and checked, and what to do when one fails.TroubleshootingLogs, resetting settings without losing connections, and what to include in a bug report.