Online MySQL Client Tools | DBHawk by Datasparc
DBHawk is an online MySQL client tool. DBHawk is a phpMyAdmin alternative with intuitive UI, ad-hoc SQL reporting, SQL Dashboarding, and SQL Job Scheduling capabilities.
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.
MySQL Online Data Browser
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.
MySQL Online Data Filter
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.
MySQL Export/Import Data
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.
MySQL Online Data Editor
DBHawk provides intuitive UI to update, insert and delete data. A user can also update and insert binary data.
MySQL Online Table Manager
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.
MySQL Online View Manager
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.
MySQL Online Column Manager
Using DBHawk, users can view column details, alter database columns, add new columns.
MySQL Online Index Manager
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.
MySQL Online Constraints Manager
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.
MySQL Online Trigger Manager
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.
MySQL Online Table Grant Manager
Using DBHawk, users can view table grants. Users can assign select, insert, update and more grants to other users
MySQL Online Stored Programs Manager
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.
MySQL Online SQL Query Builder
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.
Online SQL Editor
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.
Online SQL Report Builder
DBHawk provides ad-hoc SQL report building capabilities. A user can create PDF, Excel, CSV reports.
Online SQL Job Scheduler
DBHawk provides SQL Job Scheduling feature. Using DBHawk Job Scheduler, users can schedule reports to receive results by email or save on the disk
Online Data Charts and Dashboards
Using DBHawk, users can create various charts, create dashboards and share created charts/dashboards with other users.
Online MySQL Users Management
DBHawk allows managing MySQL users. Admin/developer can create a new user, modify existing MySQL user, drop a user.
Online MySQL Session Manager
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.
Online MySQL Database Manager
DBHawk allows to manage MySQL databases. Users can modify existing database, drop database or create new database.