About Database Master
Database Master is a modern, powerful, intuitive and easy to use MongoDB, NuoDB, MySQL, PostgreSQL, FireBird, SQLite, MS SQL Server, SQL Azure, Oracle, IBM DB2, IBM Informix, Netezza, Ingres, EffiProz administration program with a consistent and modern interface.
Database Master simplifies managing, querying, editing, visualizing, designing and reporting relational and schema-free (NoSQL) database systems. You can connect any database system via ODBC and OleDB connections, or you can connect also MS Access, MS FoxPro Database, dBASE, and XML files.
Using Database Master, you can execute SQL, LINQ, JSON queries or you can create, edit and delete all database objects such as tables, views, procedures, columns, indexes, relations (constraints), MongoDB collections and triggers. You can also view and edit table data including BLOBs (Image, Text or any file), view tables and its relations as an ER(Entity Relationship) diagram.
Database Master provides extremely powerful and intuitive SQL query editor for database queries and can execute all types of query commands. Using query editor, you can execute SQL commands or scripts against any database system. Query Editor is multi-threaded and allows long running queries and return multiple result sets. The query editor supports SQL IntelliSense (Code Completion, Table fields, SQL operators), code highlighting, text find/replace and other user friendly features.
Database Master provides powerful and intuitive JSON query editor for MongoDB database queries. It supports most used MongoDB query operations and commands. JSON Query Editor is multi-threaded and allows long running queries and return multiple result sets. The query editor supports JSON IntelliSense (Code Completion, Query Operators and Methods), code highlighting, text find/replace and other user friendly features.
Database Master provides LINQ query editor which supports dynamically LINQ to Entity Framework 4, LINQ to DataSet and Linq to XML queries. This feature allows developers to run rich LINQ query scripts using power of .Net Framework. LINQ query editor supports code Intelli-Sense (Code Completion) and code highlighting features.
Database Master allows users to export data from single or multiple database table or view objects to files. Users ca export data into most popular file formats like XML, HTML, CSV, MS Excel, MS Word, MS PowerPoint OpenOffice Calc and Writer, RTF, PDF, XPS, JSON, dBASE and PNG. You can also export whole database data and database structure (Table, View, Procedure) as a SQL Script.
Database Master allows users to import data into database table objects from XML, CSV files.Not only from files, you can import data from other database systems or files using connections. It also provides bulk SQL-Script import without any size limit and reports a data import status with a log file.
The Data Package (.datapac) feature allows you to easily bundle and export your database data as a data package and share them with others. The data package can be import again using package import feature. The benefit of Data Package feature is if you export/import sensible data, the data will not be corrupted.
Database Master allows you to manage MongoDB, PostgreSQL and MySQL database users, provides user reports and data source informations.
Database Master is one of the best management tool for MongoDB and provides powerful features like: JSON Query, Data Editor, Collection Manager, Index Manager, GridFS Manager, Visual Map&Reduce Editor, Visual Query Search, Tree and Table style data view and rich data export file formats
Database Master provides SSH tunneling, also known as SSH port forwarding. SSH tunnelling allows you to create an encrypted connection between your local machine and at the remote database engine.
Database Master provides database object reports (tables, views, procedures, collections, indexes, relations etc.)and system reports for all database engines. The users can also report the table or query result data.
Database Master provides a Table Data Editor that allows you to edit/add/delete table data (Text, Images, Files etc.) using a GUI editor. This makes it easy to alter data and add or delete rows using a GUI Editor.
Database Master is used for working with databases by over 5,000 software developers and IT professionals, in over 120 countries, personal and enterprise, science, education and technology sectors. Database Master is downloaded more than 10,000 every month!
- Multiple Database Connections [Screenshot]
- Database Manager: Create/Drop Databases
- Table Manager: Create/Edit/Drop Tables [Screenshot]
- View Manager: Create/Edit/Drop Views [Screenshot]
- Stored Procedure Manager: Create/Edit/Drop Stored Procedures [Screenshot]
- Collection Manager (MongoDB) : Manage MongoDB Collections and Indexes [Screenshot]
- Index Manager: Create/Edit/Drop Indexes [Screenshot]
- Trigger Manager: Create/Drop Triggers [Screenshot]
- Column Manager: Create/Edit/Drop Table Columns
- LINQ Queries (LINQ to Entity Framework, XML and DataSet) [Screenshot]
- Powerful SQL and JSON Query Editor with Code Highlighting and IntelliSense [Screenshot]
- Database Reports [Screenshot]
- Host (Data Source) Information [Screenshot 1,2]
- User Management [Screenshot]
- Data Visualizers: Text Visualizer, Chart Visualizer, Image Visualizer
- Table Data Editor: Create, Edit or Delete Data Records.[Screenshot]
- Database and Table Maintenance
- Table Relations (ER Modelling) [Screenshot]
- Visual SQL Query Builder [Screenshot]
- Data Export (XML, CSV, HTML, MS Excel/Word, OpenOffice, PDF, XPS, JSON etc.) [Screenshot]
- SQL Script Export: Export your database structure and data. [Screenshot]
- CSV Data Import: Import any size of CSV file. [Screenshot]
- Bulk SQL Import: Import any size of SQL file. [Screenshot]
- Data Package Export/Import: Export and import your data as a data package.
- XML Import: Import XML files into your database. [Screenshot]
- Advanced Data View [Screenshot]
- MongoDB Data View as Tree and Table Style[Screenshot]
- Search Engine: Search your data using string, datetime and number operators [Screenshot]
- Code Factory: Generate code from your database schema. [Screenshot]
- SQL/JSON/LINQ Templates and Snippets: Manage your SQL/JSON Snippets and Templates
- Database Schema (XSD) Export: Export your database schema as a XSD file.
- MongoDB: GridFS and Index Manager, User Management, Visual Map/Reduce and Query Editor [Screenshot]
- SSH Tunnelling Support
- And More...
- MongoDB 1.4.x or higher
- NuoDB 1.0.x or higher
- IBM DB2
- IBM Informix
- IBM Netezza Database
- Ingres 9.x and higher
- Oracle 7.x or higher
- MS SQL Server 2005, 2008and MS SQL Aure
- MySQL 4.x or higher
- PostgreSQL 8.x or higher
- FireBird 1.5 or higher
- SQLite Database
- ODBC and OleDB Connections
- MS Access, dBASE, XML and FoxPro Database, EffiProz Database
- OData (Open Data Protocol) Support
- Database Backup System
- Database Monitoring
- Visual Database Designer
- Data Synchronization
- Amazon DynamoDB