About Database Master

Database Master is a modern, powerful, intuitive and easy to use MongoDB, Oracle, IBM DB2, IBM Informix, Netezza, Ingres, MS SQL Server, SQL Azure, MySQL, PostgreSQL, FireBird, SQLite, EffiProz client application with a consistent interface that 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 work directly with 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, collections and triggers. You can execute SQL queries and scripts, view and edit table data including BLOBs (Image, Text or any file), represent tables and its relations as a ER(Entity Relationship) diagram.

SQL and JSON Query

Database Master provides powerful and intuitive SQL and JSON query editor to execute query commands. Using query editor, you can execute SQL&JSON commands or scripts against any database system. The query editor supports Intelli-Sense (Code Completion), code highlighting, query text find/replace and more developer friendly features.

LINQ Query

Database Master provides LINQ query editor which suports LINQ to Entity Framework, LINQ to DataSet and Linq to XML queries. This feature allows developers to run rich C# scripts using power of .Net Framework. LINQ query editor supports rich code Intelli-Sense (Code Completion) and code highlighting features.

Data Export

You can 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.

Data Import

Database Master provides you to import data from Structured-XML and CSV files. It also provides bulk SQL-Script import without any size limit and reports a data import status with a log file.


Pack&Go Data Export/Import

The Pack&Go feature allows you to export your database data as a data package and the data package file can be imported again using import feature. The benefit of this feature is that if you export/import sensible data the data will not be corrupted and imported correctly.

MongoDB Support

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, rich data export file formats

XML File as a Database

Database Master allows you to work directly with a well formed XML file as a relational database. You can execute simple SQL select, insert, update, and delete query commands directly against an XML file.

User Management

Database Master allows you to manage MongoDB, PostgreSQL and MySQL database users, provides database object reports and data source informations.


Main Features
  • 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]
  • Pack&Go Data 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 Document Tree and Table [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]
  • And  More...
Supported Data Sources

Planned Features