MySQL developers can use the visual Query builder to drag and drop database tables; build SQL queries; build SQL Server database ad hoc reports, parameterized reports, online data dashboards, build D3 based charts, and schedule reports-all with point and click simplicity and database security.
DBHawk supports full online database browsing capabilities. Users can view database table data, edit table data, insert new data, update data, delete data. A user can also create a duplicate row and update values. DBHawk data browser includes text data viewer and blob data viewer. Using these viewers, users can visually view data with a single click.
DBHawk provides advanced database filter on the table and view data. With simple clicks, users can apply table data where condition and order by conditions.
Using DBHawk, users can export table data, SQL Query results data, view data into HTML, CSV, Excel, PDF formats. Users can save exported data to local disk or directly to Amazon S3 storage. Using DBHawk import CSV feature, users can import CSV data into database tables.
DBHawk provides intuitive UI to update, insert and delete data. A user can also update and insert binary data.
Using DBHawk, users can create a new table, rename a table, drop a table, count total rows in a table, change table engine, view column details with all simple clicks and intuitive web-based UI.
Using DBHawk, users can create a new view, rename a view, drop a view, count total rows in a view, modify a view, filter view data, view column details with all simple clicks and intuitive online UI.
Using DBHawk, users can view column details, alter database columns, add new columns.
Using DBHawk, users can view index details including index uniqueness, index type, index columns, index statistics. Users can also add new with a new index screen and preview SQL prior to creating an index.
Users can drop an index.
SQL constraints are used to specify rules for the data in a table. Using DBHawk, users can view constraints details including constraint type, constraints columns. Users can add new Primary key, foreign key, and Unique key constraints through web-based UI.
Users can drop a Constraint.
Using DBHawk, users can view trigger details including trigger type, trigger events. Users can also add a new trigger to a new trigger screen and preview SQL prior to creating a trigger.
Users can drop the trigger.
Using DBHawk, users can view table grants. Users can assign select, insert, update and more grants to other users
Using DBHawk, users can manage database functions, procedures, and triggers. A user can add new stored programs, modify existing MySQL stored programs. DBHawk online code editor includes syntax highlighting, find, replace, replace all features.
This feature assists in Building complex SQL Queries. It is basically a Web-based intuitive UI. It is capable of building queries by simply dragging and dropping. It also builds tables relationships automatically. While building SQL Queries, it displays online data preview. Users can build SQL Queries online without writing any SQL code. This is a useful feature for business users, who would like to do analytics on data without writing complex SQL queries.
Using DBHawk advanced Online SQL Editor, users can execute SQL queries. It also Formats SQL queries. It enables to View SQL query history. This feature helps in Grid data sorting and filtering. The Grid data columns selection is also done with the help of this feature. It supports and applies math functions to grid data.
DBHawk provides ad-hoc SQL report building capabilities. A user can create PDF, Excel, CSV reports.
DBHawk provides SQL Job Scheduling feature. Using DBHawk Job Scheduler, users can schedule reports to receive results by email or save on the disk
Using DBHawk, users can create various charts, create dashboards and share created charts/dashboards with other users.
DBHawk allows managing MySQL users. Admin/developer can create a new user, modify existing MySQL user, drop a user.
DBHawk allows managing MySQL connections. DBHawk session manager displays Logged in User, Host, DB Name, Command, Time, and SQ Information. It also allows killing session.
DBHawk allows managing MySQL databases. Users can modify the existing database, drop a database or create a new database.