Investigate Production Data
Quickly inspect tables, views and query results when troubleshooting data issues, without building a report or export first.
Who Is It For?
Database Admins
Simplify database monitoring, maintenance, and troubleshooting across multiple systems.
Developers
Query multiple databases easily, prototype ETL workflows, and edit data directly.
Reporting Pros
Export data quickly, create reusable queries, and streamline your reporting tasks.
Key Features
1
Multi-Database Connectivity
Connect to SQL Server, Oracle, MySQL, SQLite, ODBC, and more. Open multiple connections simultaneously in an MDI interface. Query across databases and even different database types in a single session.
2
Virtual Connection
Combine data from grids across different databases into a single query window. Perform cross-database joins effortlessly — no ETL pipelines needed. Query data in real time, breaking down silos between systems.
3
Query Management
All executed queries are logged automatically. Search query history to find specific commands, mark favourites, give them names, and access them via a dropdown menu. Perfect for database monitoring and maintenance workflows.
4
Flexible Table Views
View tables in read-only mode by default for safe browsing. Enable write mode for direct data editing. Use real-time filtering to instantly find tables, views, or stored procedures by keyword.
5
Advanced Grid Features
Move and freeze columns, sort by headers, and add a totals row for numeric columns. Add a search bar to locate specific text within the grid. Export data to CSV, Excel, or a memory grid for further analysis. Tag grids with custom names to query them in virtual connections.
6
Team Collaboration Coming Soon
Shared query repository for storing and sharing queries among team members. Promote consistent, efficient workflows with a centralized query library.
Typical Use Cases
Data Digger is built for practical day-to-day database work: quick investigation, data validation, ad hoc analysis and reporting support.
Compare Data Between Systems
Load data from different databases or files and compare records across systems, for example between SQL Server, Oracle, Excel or ODBC sources.
Validate Imports and Migrations
Check whether imported, converted or migrated data matches the expected result before it is used by business users.
Support Reporting Users
Run ad hoc queries, verify report data and export results to Excel, CSV or HTML for further analysis.
Reuse Common Queries
Save frequently used SQL statements, keep query history and avoid rewriting the same investigation queries again and again.
Analyze Data Without ETL
Use the Virtual Connection to work with loaded grids and perform quick cross-source analysis without creating temporary ETL flows.
All Features at a Glance
- Multi-database support (10+ engines)
- Auto-complete SQL
- Virtual cross-database connections
- Real-time table filter
- MDI interface — multiple connections
- Memory grids
- Full query history log
- Export to Excel, CSV, HTML, TXT
- Favourite query shortcuts
- Editable text dump
- Read-only & write table modes
- Freeze and move columns
- Numeric column totals row
- Custom row highlight colors
- Grid-level search bar
- Shared query repository Coming soon
Feature Comparison
Data Digger is designed for fast ad hoc data investigation across multiple sources, while tools like SSMS are mainly focused on database administration.
| Feature | Data Digger |
SSMS | Generic SQL Tool |
|---|---|---|---|
| SQL Server | ✓ | ✓ | Usually |
| Multiple database types | ✓ | ✕ | Often |
| Excel / CSV workflow | ✓ | Limited | Varies |
| Query favorites | ✓ | Limited | Varies |
| Virtual cross-source grids | ✓ | ✕ | Rare |
| Compare different sources | ✓ | ✕ | Rare |
| Reuse loaded data | ✓ | ✕ | Rare |
| Read-only by default | ✓ | ✕ | Varies |
| Export results | ✓ | Limited | Usually |
| Grid productivity tools | ✓ | Limited | Varies |
| Lightweight Windows tool | ✓ | ✕ | Varies |
| Ad hoc investigation | ✓ | Limited | Usually |
| Full DB administration | ✕ | ✓ | Varies |
✓ = supported, ✕ = not supported or not the intended purpose.