Introduction

OmniDB is a web tool that simplifies database management focusing on interactivity, designed to be powerful and lightweight. Check-out some characteristics:

Web Tool: Accessible from any platform, using a browser as a medium
Responsive Interface: All available functions in a single page
Unified Workspace: Different technologies managed in a single workspace
Simplified Editing: Easy to add and remove connections
Safety: Multi-user support with encrypted personal information
Interactive Tables: All functionalities use interactive tables, allowing copying and pasting in blocks
Smart SQL Editor: Contextual SQL code completion
Beautiful SQL Editor: You can choose between many available color themes
Tabbed SQL Editor: Easily add, rename or delete editor tabs

Technologies:

ASP.NET
C#
HTML + CSS + JavaScript

Supported Platforms:

Linux
Windows
OS X

Supported DBMS:

MySQL
Oracle
PostgreSQL
Firebird
SQLite
Microsoft SQL Server
Microsoft Access

Database Schema Management

OmniDB is designed for easy database management. Here are some features:

Tree view showing database structure
- Included structures:
  - Columns and Tables
  - Key Constraints: primary, foreign and unique
  - Index (unique and non-unique)

Powerful table creation
- Editing capabilities:
  - Tables' names
  - Columns: name, type and nullable
  - Primary keys and respective columns
  - Foreign keys with either table and reference columns, including updating rules and removal as well
  - Indexes

Table editing: Edit table structure according to DBMS limitations
Data management: Add, edit and remove records

SQL Editing
- Customizable Features:
  - Syntax highlighting for SQL
  - SQL code completion for table columns and subquery
  - Multiple themes to be selected

Other features:
- Querying organized in tables
- DDL commands execution
- Multiple sequenced command execution (scripts)
- Bar charts demonstrating registry numbers contained in the denser tables (limited to 100)
- Graphs displaying tables and their relations
- Graphs displaying tables, relations and color scale based on record density

Graphs displaying complete ER diagram

Database Schema Conversion

Since version 1.3, OmniDB is able to convert one schema to another, regardless of the DBMS. It is very useful to convert databases, from any supported DBMS to any supported DBMS.

Here are the structures supported by OmniDB database conversion:

Tables
Primary Keys
Foreign Keys
Uniques
Indexes
Table data