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
• Microsoft SQL Compact (Windows only)

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