miMas - GUI tool for SQL developers

By Author: shakeelkorbu
miMas is an intuitive GUI tool for SQL query development and data browsing. It provides a common set of features across all databases and can be installed on any Operating System which has a Java Runtime available.

The tool uses JDBC drivers for connecting to a database. For most popular databases (Oracle, DB2, MySQL, MS SQL Server, Sybase, Cloudscape, PostgreSQL and Firebird), the JDBC driver is already included. For connecting to databases other than these, please refer to the tool's user manual.

Feature

  • Auto suggest - Tables/Columns/Functions/Templates/Alias for SQL query building
  • Tabs - Work on multiple queries or connect to multiple databases and schemas
  • Queries - Preview queries, batch execution, parameterization, query templates
  • Records - Edit, filter, sort, JSON/XML view, copy inserts, rows, cells and column values
  • Intuitive and Beautiful UI - With two themes - Blue and Gray
  • Query building - Build insert, update, delete and select queries using an intuitive UI
  • Transaction support - Execute queries as part of a transaction with Commit/Rollback option
  • Describe - Get table information - Primary keys, Foreign Keys, References, Index
  • Ease - Keyboard shortcuts, syntax highlighting, matching braces, find/replace text
  • Fast - Progressive retreival of records in sets, along with option to fetch exact
  • Export (CSV / TSV / EXPDAT) and import data (CSV / EXPDAT)
  • Workspace - Save and restore, save/load sql queries, load last tab state
  • Configurable - Save connections and tool settings
  • Power of JDBC - Common feature set across any database with a JDBC driver
  • Tiny - Execution JAR file is small and it isn’t memory intensive
  • Portable - OS independent, no installation required, supports ODBC drivers
  • Security - Built using Java, hence runs in its own runtime environment
  • Help - User manual for reference

MySQL, Oracle, Postgre DB query browser

This program can help you to connect to the SQL server and execute queries, inserts, updates, show results, browse through DB schemas, tables. It has converter from timestamp date to regular date format and vice versa + Backup and Restore of MySQL DB + export to CSV file. Not need to install, just.........

Similar: 18%

NE DB Comparator

DB Comparator is a simple to use tool to compare and sync MS SQL Server databases. It shows all data object differences side by side in a hierarchical tree view. It compares tables, views, indexes, constraints, procedures, functions and user data typ...

Similar: 17%

The Hironico Db Tool

The Hironico Db Tool is a graphical database client that can run on all major platforms today. It provides a powerfull, feature rich and user friendly set of tools to work with databases of any vendor using Java drivers while being fast & light....

Similar: 16%

UCanAccess

UCanAccess is a pure Java JDBC Driver implementation which allows java developers and jdbc client programs to read/write Microsoft Access database (.mdb and .accdb files). No ODBC needed....

Similar: 16%

CrystalDB Tool

CrystalDB Tool is used by developers, DBAs and analyst for managing, administering and developing databases. The utility supports the two common database management system, namely MS SQL Server and Oracle. It provides an editor that offers code completion and syntax highlighting for standard SQL. I.........

Similar: 15%

XDO Client

This Java program is designed to help developers to create, test, and demo Oracle XML/BI Publisher reports without logging to the EBS suite or BI Publisher server. This program is capable to: (1) Taking Data Template file to generate XML data (2) Taking XML data file to generate reports (3) Running .........

Similar: 15%

ERMaster

ERMaster is Eclipse plug-in to make ER diagram. Functionally, Import from data base, Making of table definition book on Excel, Image output, DDL output, etc. are being offered....

Similar: 14%

heidisql

HeidiSQL is a useful and reliable tool designed for web developers using the popular MySQL server, Microsoft SQL databases and PostgreSQL. It enables you to browse and edit data, create and edit tables, views, procedures, triggers and scheduled events. Also, you can export structure and data either .........

Similar: 12%

Open Source Data Quality and Profiling

This project is dedicated to open source data quality and data preparation solutions. Data Quality includes profiling, filtering, governance, similarity check, data enrichment alteration, real time alerting, basket analysis, bubble chart Warehouse validation, single customer view etc. defined by Str.........

Similar: 9%

Lioness (Languages Interop Framework)

Framework for making Windows applications that are one .exe file in AutoHotKey_L,C++,C#, VB.NET,Java,Groovy,Common Lisp,Nemerle,Ruby,Python,PHP,Lua,Tcl,Perl,Jint,S#,WSH VBScript,HTML/JavaScript/CSS,COM, PowerShell without compiling . For .NET 4....

Similar: 9%