DataPad++ documentation

Work safely across every datastore

Step-by-step guides for the workbench, all seven plugins, common tasks, diagnostics, transfers, and all 29 declared datastore engines.

Start here

Install And Update DataPad++Download the right desktop artifact, install it, and understand updater behavior.First Launch ChecklistOrient yourself in the workbench before connecting to important systems.Tour The DataPad++ InterfaceLearn every navigation surface before you connect or run a query.Run Your First QueryConnect to your datastore, select its scope, run a bounded read, and inspect the result.

Connections and organization

Create And Edit ConnectionsChoose a connection method, open or create a local database, manage saved credentials, and leave an edit safely.SQL Server Windows Login And Microsoft EntraConnect with your current Windows account or sign in to Microsoft Entra in your system browser.Use Environments And VariablesKeep risk, secrets, and target context visible while you work.Save Work In The LibraryOrganize connections, saved queries, scripts, notes, tests, and reusable snippets.Check Connection HealthTest connectivity, inspect capability warnings, and diagnose a failing profile.

Navigate and inspect

Explore Datastore ObjectsUse datastore-native object trees and context menus before writing queries.Explore Datastore MetadataBrowse each datastore through its native hierarchy and purpose-built detail views.Use SQL Relationship DiagramsUnderstand table shape, joins, and schema boundaries before writing broad SQL.Navigate Large Oracle SchemasPage through large object catalogs and let IntelliSense complete the schema selected on the query tab.Inspect Objects And MetricsOpen object views, inspect metadata, and use metrics without losing query context.Use Tabs, Panels, And DrawersManage workspace tabs and place supporting information where it is easiest to compare.

Query and edit

Query In The Right ModeChoose raw editors, visual builders, consoles, and scoped query surfaces.Use Query History And ExplainReview previous executions, reopen a query, and inspect safe execution plans.Build Valid Typed QueriesCreate nested filters with type-aware values, validated JSON, and native array predicates.Select SQL Database And Schema ScopeKeep database and schema context on the query tab instead of repeating session-selection statements.Inspect Results And Edit SafelyRead table, document, raw, and key-value results with safe editing boundaries.Edit Document Results SafelyAdd or remove fields, use native typed inputs, and validate raw JSON before datastore execution.Inspect A Complete Key-Value ValueOpen, format, copy, and safely edit authoritative values without relying on shortened cell previews.

Move and protect data

Import, Export, And Backup DataUse guarded desktop file workflows for portable data movement.Export Result FilesExport accumulated loaded results or stream a supported original query, with explicit limits and progress.Import, Export, Backup, And Restore Datastore DataUse native and portable formats through a staged, conflict-safe transfer workflow.Use The Transfers CenterStart a supported transfer, monitor progress, and recover from warnings or failures.Settings, Workspace Bundles, And BackupsConfigure appearance, workspace security, encrypted exports, and automatic backups.Import Or Export A WorkspaceMove a versioned workspace safely, choose whether secrets travel, and activate the imported workspace immediately.Analyze Workspace And Backup SizeFind large histories or cached payloads using byte-only diagnostics without exposing private content.

Plugins

Choose And Manage PluginsUnderstand every DataPad++ plugin, enable only what you need, and open its working surface.Use The Workspaces PluginCreate, switch, rename, and safely maintain named local DataPad++ workspaces.Search The WorkspaceFind connections, Library work, open tabs, closed tabs, scripts, queries, and test suites quickly.Move Tabs Between WindowsEnable the experimental desktop workspace and move eligible working tabs without creating another application session.Run A Local API ServerExpose selected datastore resources and saved queries as local REST, GraphQL, or gRPC endpoints.Connect Local MCP ClientsUse the desktop-only MCP Server with scoped tokens, setup snippets, metrics, and logs.Review Datastore Security ChecksScan datastore versions for vulnerabilities and review local/read-only posture checks.Build Datastore Test SuitesCapture repeatable setup, execute, assertion, and teardown checks beside the datastore they validate.

Automate and diagnose

Configure Appearance, Shortcuts, And LogsNavigate all eight Settings sections and safely collect diagnostic logs.

Safety and troubleshooting

Safety ModelLearn why DataPad++ disables, previews, or confirms risky actions.Understand Datastore CoverageUnderstand which datastore features are available, guarded, in preview, or unavailable before you rely on them.

Datastore guides

SQL Family WorkflowsWork with PostgreSQL, SQL Server, MySQL, MariaDB, SQLite, CockroachDB, TimescaleDB, DuckDB, Oracle, and related engines.MongoDB WorkflowsBuild queries, inspect documents, review explain plans, and manage collection workflows.Redis And Valkey WorkflowsBrowse keys, inspect types, run console commands, and protect key operations.Search, DynamoDB, And Secondary EnginesUnderstand preview-first workflows for search, wide-column, cloud, graph, warehouse, metrics, and local engines.

All 29 datastores

Datastore guide indexConnection fields, native workflows, sample reads, capabilities, diagnostics, transfers, limitations, and troubleshooting.