Unlock Efficient SQL Management with Waterdrop: A Complete Guide

Waterdrop Overview

Waterdrop is a cross‑platform database management tool provided by TDH for developers and DBAs. It serves as an Inceptor SQL client and supports many other databases.

Core Modules

Database Navigator – view connections, metadata (databases, tables, columns, partitions, buckets, views, stored procedures, packages) and create or edit DDL directly. It also allows comparing multiple metadata objects and generates reports on structural and data differences.

SQL Editor – offers syntax highlighting, error detection, automatic formatting (Ctrl+Alt+F), code completion, context help (F2), SQL templates, and conversion between standard SQL and programming‑language strings.

Highlight errors by lexical and syntactic analysis.

Format SQL statements.

Auto‑complete keywords and object names.

Context help for selected entities.

Predefined SQL templates (e.g., scgb expands to select col,count(*) from table t group by col;).

Advanced copy to convert selected SQL to Java, C#, etc., and vice‑versa.

SQL Executor – execute and debug SQL with buttons or shortcuts, and export query results to XML, JSON, HTML, CSV, database tables, or XLSX.

Data Viewer/Editor – edit, delete, copy, and paste data directly in the result view, with changes reflected in the source table. Certain columns can be protected from modification. It also supports row deletion, insertion, and advanced copy/paste with custom delimiters.

Additional Tools (Waterdrop 5.0)

Data Import Tool – import data from any source table to a target table based on field mappings.

Data Export Tool – export table data or query results to external files.

Stored Procedure Test Tool – run stored procedures with user‑provided parameters and view results.

Acquisition

Waterdrop can be downloaded from a shared network drive (password snj5) or, for clusters version 5.0+, via the “More Operations” menu in Transwarp Manager.

Note: Waterdrop requires the inceptor‑sdk; both must be installed.

License

Since version 5.0, a license issued by Transwarp is required to connect to Inceptor. Users without a valid license must request one from support.transwarp.io. The process involves obtaining a company‑specific secret key from sales and then using it on the self‑service portal to download the license.

Conclusion

Waterdrop provides a powerful SQL IDE that simplifies SQL development, debugging, and data manipulation, boosting development efficiency for database‑centric projects.