DPSQLConnect: A Desktop SQL Client for ERP and Database Professionals
DPSQLConnect is a desktop SQL client built specifically for database professionals working with Oracle, PostgreSQL, MySQL, SQLite, and SQL Server. Unlike generic database tools, DPSQLConnect is designed around the workflows that ERP and supply chain practitioners actually use — bulk data browsing, BLOB inspection, JSON/XML visualisation, and hierarchical data navigation.
This article covers what DPSQLConnect does, how it was built, and the engineering decisions behind it.
What DPSQLConnect Is
DPSQLConnect is a Java-based desktop application that connects to multiple database types through a unified interface. The core design principle is that the tool should handle data the way analysts actually work — not just run queries, but explore, visualise, and understand complex data structures without writing boilerplate code.
The application ships as a standalone installer for Windows. It requires no separate database client installation; drivers are bundled for all supported databases.
Key Features
Multi-Database Support
DPSQLConnect connects to five database platforms through a single connection manager:
| Database | Connection Method | Notes |
|---|---|---|
| Oracle | JDBC thin / TNS / Wallet | Full OCI support including ADB |
| PostgreSQL | JDBC | SSL and certificate auth supported |
| MySQL | JDBC | MariaDB compatible |
| SQL Server | JDBC | Windows auth and SQL auth |
| SQLite | Direct file | No server required |
Column-Level Data Editing
Standard SQL clients display data in read-only grids or require full UPDATE statement authoring. DPSQLConnect provides inline column editing — double-click any cell to edit it, with automatic UPDATE statement generation. Changes are staged before commit, giving users a preview of what will be written.
This is particularly useful for ERP data correction workflows where a DBA or analyst needs to fix a handful of records without writing repetitive SQL.
BLOB and CLOB Visualisation
Binary and character large objects are a consistent challenge in SQL clients. DPSQLConnect handles them with dedicated viewers:
- Image BLOBs render inline in the data grid — useful for product images stored in Oracle EBS or similar systems
- PDF BLOBs open in an embedded viewer
- XML CLOBs display in a formatted tree view with syntax highlighting
- JSON CLOBs display in a collapsible tree with search
JSON and XML Tools
Beyond LOB viewing, DPSQLConnect includes a standalone JSON/XML workspace:
- Paste or load any JSON or XML document
- Validate against schema
- Transform with JSONPath or XPath queries
- Compare two documents side by side
- Export formatted output
Hierarchy and Comparison Tools
Two tools address common ERP data analysis needs:
Hierarchy Viewer — given a self-referencing table (parent_id → id), DPSQLConnect renders the data as an interactive tree. This works directly with BOM tables, category hierarchies, organisational structures, and approval chains. No SQL required — select the table, identify the key and parent columns, and the tree renders automatically.
Record Comparison — select two rows from any table and view a side-by-side diff of every column. Highlights additions, deletions, and changes. Useful for auditing data changes, comparing configuration between environments, or debugging ERP record discrepancies.
Theme System
DPSQLConnect ships with multiple UI themes covering both dark and light preferences. Themes apply across all panels — the query editor, data grid, result panels, and tool windows — ensuring a consistent visual experience regardless of which feature is in use.
Theme preferences are saved per user profile, so teams with different display setups maintain their own configurations.
Technical Architecture
DPSQLConnect is built on Java with a Swing-based UI. The choice of Java reflects two priorities: cross-platform JDBC driver availability (every major database has a mature Java driver) and long-term stability for a desktop tool that needs to run reliably without frequent updates.
Key architectural decisions:
- Driver bundling — all JDBC drivers are included in the installer. Users never need to download or configure drivers separately
- Encrypted credential storage — connection passwords are AES-256 encrypted at rest using a machine-specific key. Wallet files are stored in a protected application directory
- Staged commits — all edits in the column editor are held in a local change set until explicitly committed. A preview dialog shows the exact SQL that will be executed
- Query history — every executed query is logged locally with timestamp, database, execution time, and row count. The history is searchable and queries can be re-executed directly from the log
Video Demonstrations
DPSQLConnect includes a 7-part video series demonstrating the full feature set:
- Overview — connection setup, interface tour, basic query execution
- Column Editing — inline editing, staged commits, UPDATE preview
- BLOB and Chart Tools — image/PDF BLOB viewing, result set charting
- JSON and XML — LOB visualisation, JSONPath queries, XML tree view
- Data Tools — export, import, bulk operations, data comparison
- Themes and Preferences — theme switching, profile management, keyboard shortcuts
- Hierarchy and Comparison — BOM tree rendering, side-by-side record diff
What It Is Not
DPSQLConnect is a personal development project, not a commercial product. It is not a replacement for Oracle SQL Developer, DBeaver, or DataGrip. Those tools have larger teams, broader feature sets, and enterprise support. DPSQLConnect is built for specific workflows — ERP data analysis, BLOB inspection, BOM visualisation — where the mainstream tools require more manual effort.
The application is not open source. It is distributed as a compiled installer for evaluation purposes.
*DPSQLConnect is a personal project by DhirajKumar Pathak. Distributed for evaluation and learning purposes. Not a commercial product or professional tool.*
Comments (0)