Introduction to OmniDB

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

And here are some features of OmniDB -

• 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