Data Editor

Dedicated Relational Data Editors

Grid View

Edit multiple records across your table without automatic saving. Clear color-coded highlights pinpoint changed fields, while an integrated status bar tracks pending updates. Easily review every edit and apply or discard your changes in a single batch.

Form View

Edit individual records in a clean, vertical layout designed for deep-dive inspection. Easily handle long text fields or wide tables without horizontal scrolling.

Bypass tedious "Next / Previous" clicking with an integrated sidebar that lets you jump directly to any record and customize preview fields for faster scanning.

Fill with AI

Populate, translate, and analyze records directly inside your table views. Fill with AI uses your existing columns as context to generate, convert, or summarize information across multiple fields at once - saving hours of manual editing and external tool switching.

What You Can Do

Multi-Field Mapping: Map inputs from specific source fields to populate multiple destination columns at once. For instance, read raw text to concurrently generate corrected content, a numeric score, and qualitative feedback in a single step.

Custom AI Personas: Set tailored AI instructions, target formatting, or specific perspectives to match your workflow.

Safe Preview Window: Review AI suggestions before applying changes directly to your database.

Reusable AI Actions: Save your favorite prompt configurations to rerun on future datasets with a single click.

Data Mocking & Fill:

Instantly populate empty cells or generate realistic test data based on existing schema context.

Translation:

Translate entire text columns across multiple languages right inside your editor.

Data Cleansing & Insights:

Summarize long text blocks, categorize records, or flag inconsistencies automatically.

And Much More:

You can apply any custom instruction to handle your unique data tasks.

Data Profiling

Evaluate data health, spot quality issues, and analyze value distributions across your datasets. Optimize performance on large tables by scanning entire datasets or sampling specific row subsets.

Column Quality & Distribution: Track data completeness with percentage bars directly under each column header to view distinct, unique, NULL, and non-NULL counts. Analyze value frequencies using interactive histograms with flexible Compact and Detailed view modes.

Column Statistics: Access in-depth statistical breakdowns for individual columns, reviewing key metrics like Count, Distinct, Unique, Empty String, Min, and Max alongside distribution charts.

Spotlight: Isolate key values or compare outliers across all charts and tables. Select single or multiple data points to dynamically highlight and focus on specific items of interest.

Specialized Cell Editors

Text Editor
View and edit plain text with automatic syntax highlighting for formats like XML, HTML, and CSS.

JSON Editor
Inspect and format nested JSON structures with direct key-value pair editing.

Hex Editor
View and update raw binary or BLOB data directly in hexadecimal format.

Image Viewer
Render image files inside cells, with quick options to upload, export, or clear image data.

Web View
Render HTML content as live, fully styled web pages right inside your editor.

Foreign Key Navigation

Instant Relational Lookup: Jump straight to referenced parent records or preview linked details in a quick pop-up window.

In-Context Filtering & Search: Search, sort, and preview additional reference columns directly inside the selection window to pinpoint target records instantly.

Raw Mode Editing

Execute server functions and raw SQL expressions directly inside individual data fields. Apply dynamic calculations, default functions, or complex updates on the fly without writing standalone queries.

Finding, Filtering & Sorting

Find & Replace

Search cell values dynamically as you type, step through matching entries, and execute bulk replacements with pre-commit change reviews.

Go to Record

Jump straight to any row position on the active page.

Flexible Filtering

Right-click cell values to filter instantly, or build multi-condition rules in the Filter & Sort pane. Switch seamlessly between visual controls with togglable criteria and a dedicated text mode featuring smart auto-complete.

Multi-Level Sorting

Sort single columns directly from column headers or combine multiple fields in the Filter & Sort pane to establish custom sorting hierarchies.

Clipboard & Quick Export

Smart Clipboard Exchange: Copy grid records seamlessly into spreadsheets like Excel with automatic tab and row delimiting, or paste clipboard data directly to update or append records.

Copy as SQL & JSON: Convert selected rows instantly into executable INSERT or UPDATE statements, or formatted JSON data to use in any external editor.

Flexible Field Copying: Choose exactly what goes to your clipboard - raw field values, column headers only, or tab-separated headers with data - in a single right-click action.

Quick File Export: Save cell contents or grid selections directly as text (.txt) or image (.png) files without launching full export wizards.

Session History

Track, audit, and reuse database operations across your entire session in real time.

Real-Time Query Stats: Monitor live activity counters for SELECT, INSERT, UPDATE, and DELETE operations alongside total query and error counts at a glance.

Detailed Audit Logs: Inspect complete command histories with exact query statements, execution status messages, and precise timestamps.

Instant Query Reuse: Open any historical statement directly in a new query window to edit, refine, or re-run.

Custom Layouts

In-Header Field Info

Display data types and field comments right in your column headers. You can understand data structures and input requirements instantly without switching to table design view.

Move & Reorder Columns

Drag and drop column headers to reorder fields for optimal visibility and faster data entry.

Freeze Columns

Pin key columns to the left side of your screen so they stay visible for easy reference while scrolling horizontally across wide tables.

Show & Hide Columns

Toggle off non-essential fields to keep your view clean, focused, and free of unnecessary horizontal scrolling.

Table Profile

Save custom filters, sorting rules, and column layouts to instantly restore your tailored workspace.

Save Custom Workspaces: Capture your exact view configuration - including active filters, sort orders, and visible columns - for fast reuse.

Instant Main Window Access: Access saved profiles directly under corresponding table objects in the main window to launch customized views in a single click.

Dedicated NoSQL & In-Memory Editors

Tailor your editing experience with purpose-built tools for document and key-value databases.

MongoDB Data Editor

Grid View: Present document fields in a clean tabular layout for fast inline updates.

Tree View: Navigate complex nested documents, sub-documents, and arrays using expandable tree structures.

JSON View: Modify and format raw document structures directly using native JSON syntax.

Learn more

Redis Data Editor

Flexible Views: Switch between flat Grid View lists and namespace-grouped Tree Views for visual key navigation.

Direct Key Editing: Modify key names, values, data types, and TTL expiration times on the fly.

Key Search & Sorting: Filter keys instantly using pattern matching and sort keys by key name, data type, or TTL.

Learn more