Publisher's description - DBExplorer 2 1.0
DBExplorer 2 is a powerful database tool that allows you manager many databases which includes the mainstream databases(MySQL, MariaDB ,PostgreSQL,SQLite,MongoDB,Redis,LevelDB,Memcached, Cassandra,Microsoft Access MDB).It also can inspect apple CoreData model data of objc-based app.
Build-in SSH tunnel can connect remote server easily,also ensure data security.
For relation-DBMS like MySQL, MariaDB ,PostgreSQL,SQLite, main features includes:
-Create/Delete database
-Database Table Graph
-Create/Delete table
-Modify table schema, update table column order by drag/drop column(only valid for MySQL,SQLite).
-Drag/Drop table from one database to another database(only valid for same database type).
-Create/Delete table index
-Insert/Delete/Edit table data
-Page browse table data,right-click menu can copy row data as json/xml/csv to pasteboard.
-Table data browse filter
-SQL syntax highlighting & key words Auto-Complete
-SQL history,double-click history sql to execute;
-SQL query results export as SQL/JSON/CSV/XML
-Generate random test data
-Table Data Import/Export(SQL/JSON/CSV/XML)
For MongoDB, main features includes:
-Create/Delete database
-Create/Delete collection
-Insert/Delete/Edit collection data
-Double-Click row data for edit
-Page browse collection data
-JSON condition query,db.collectionname.find/update/remove/insert/count operation command,query results export as JS/JSON
-Data import from JSON text file.
-Data export as JS/JSON.
For Redis, main features includes:
-Click dB node means select this DB for operation;
-Double-Click key for edit
-Create/Delete/Edit key for any key type(String,Hash,List,Zset,Set)
-Key filter query,query results export as json or redis command
-Run redis command
-Data import from redis command file
-Data export as json or redis command
For LevelDB, main features includes:
-Add/remove key;
-Create Database;
-Page browse data
For CoreData, main features includes:
-Add/remove/Edit Row Data;
-Page browse data;
-Predicate Query & Query result export.
-Data Import/Export(SQL/JSON/CSV/XML)
For Memcached, main features includes:
-Add/remove/Edit Key
-Page browse key
-Key action(GET/SET/INCRE/DECRE)
-Stats Information
For Access MDB File DB, main features includes:
-Page browse data
-Table Schema info
-Data Export(SQL/JSON/CSV/XML)
For Cassandra, main features includes:
-Create keyspace/Table(Column Family)
-Page browse data
-BrowseTable field
-Add/Remove Table Data
-Generate random test data
Other features:
-Click App Menu DBExplorer->Preferences,modify browse data row max numbers
- Right-Click left panel any type node(connection,database,table,key,collection) active different context-menu
-Connection profile manager window,Click auto-login column, active auto-login.
-For SQLite/LevelDB, you can drag/drop database file on left tree panel to open it.
In-App Purchase:
in order to increase sales, DBExplorer will bother you in regular.
If you like DBExplorer,please rate it on Mac App Store,thanks!
You can visit our home page for more information(http://www.dbappx.com/)
any issue/suggestion please email dbappx@gmail.com