Fork me on GitHub

OmniDB

Open Source Collaborative Environment
For Database Management

Support Status

  • PostgreSQL
  • Oracle
  • Firebird
  • MySQL
  • MariaDB
  • SQLite
  • SQL Server
  • IBM DB2

Send Us Your Feedback

Powered by BreezingForms

Technology Can Improve Your Workspace!

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

Overview

Details

Technology
  • Python (3.5+)
  • Django
Libraries

Tool Support

Platforms:
  • Linux
  • Windows
  • OS X
DBMS:
  • PostgreSQL
  • MariaDB (WIP)
  • Oracle (WIP)
  • MySQL (WIP)
  • SQLite (WIP)
  • Firebird (WIP)
  • SQL Server (WIP)
  • IBM DB2 (WIP)

Features

Easy to Manage

Data structure visualization works like an interactive tree, with each nodes' context menu containing access to every available action regarding it.

Included structures:

  • Columns and Tables;
  • Key Constraints: primary, foreign and unique;
  • Index: unique and non-unique.

The user can easily switch between database connections picking from a simple dropdown menu located above the tree.

Table Editing

It's possible to edit existent tables, being able to alter any item from the previous topic.

This feature depends on the restriction of each DBMS technology.

SQL Editing

It's also an interactive and customizable SQL editor.

Customizable Features:

  • Syntax highlighting for SQL;
  • SQL code completion for table columns and subquery;
  • Multiple themes to be selected.

Table Creation

Powerful interface to create new tables.

 

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.

Data Management

It's possible to add, edit and remove tables' records.

If the table contains primary key, existent records may be altered or removed, if not, only new records may be inserted.

Other Features

Inspite of its light design, OmniDB aims to be a solid and complete tool, posessing many other facilitating features.

The OmniDB Team is looking forward to receive your feedback, feel free to submit your opinions and share experience.

We would like to encourage you to:

Thank you for your visit!