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
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
- 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
