2ndQuadrant | PostgreSQL
Mission Critical Databases
+33 9 72 17 01 31
  • Contact
  • FR
    • EN
    • IT
    • ES
    • DE
    • PT
  • Support & Services
  • Downloads
    • Installateurs
      • Postgres Installer
      • 2UDA – Unified Data Analytics
    • Livres Blancs
      • Etude de cas pour le Support PostgreSQL
      • Bonnes Pratiques de Sécurité
    • Etudes de Cas
      • Migration Base de Données
        • International Game Technology (IGT)
        • Healthcare Software Solutions (HSS)
        • Navionics
      • Optimisation de Performances
        • BenchPrep
        • tastyworks
      • Clusters Bases de Données Distribuées
        • ClickUp
        • European Space Agency (ESA)
        • Animal Logic
        • Telefónica del Sur
      • Mises à Jour Bases de Données
        • Alfred Wegener Institute (AWI)
      • Support & Administration Base de Données
        • Met Office
        • Agilis Systems
        • London & Partners
  • Formation: Postgres Learning Center
    • Webinars
      • Archives – Webinar Library
    • Livres Blancs
      • Etude de cas pour le Support PostgreSQL
      • Bonnes Pratiques de Sécurité
    • Blog
    • Formation
      • Catalogue des Formations
    • Etudes de Cas
      • Optimisation de Performances
        • BenchPrep
        • tastyworks
      • Clusters Distribués
        • ClickUp
        • European Space Agency (ESA)
        • Telefónica del Sur
        • Animal Logic
      • Administration Bases de Données
        • Agilis Systems
      • Formation Professionnelle
        • Met Office
        • London & Partners
      • Mises à Jour Base de Données
        • Alfred Wegener Institute (AWI)
      • Migration Base de Données
        • International Game Technology (IGT)
        • Healthcare Software Solutions (HSS)
        • Navionics
    • Livres
      • PostgreSQL 11 Administration Cookbook
      • PostgreSQL 10 Administration Cookbook
      • PostgreSQL High Availability Cookbook – 2ème Edition
      • PostgreSQL 9 Administration Cookbook – 3ème Edition
      • PostgreSQL Server Programming Cookbook – 2ème Edition
      • PostgreSQL 9 Cookbook – Edition en Chinois
    • Vidéos
    • PostgreSQL
      • PostgreSQL – L’Histoire
      • Qui Utilise PostgreSQL?
      • Foire aux Questions PostgreSQL
      • PostgreSQL et MySQL
      • L’Etude de Cas pour PostgreSQL
      • Informations de Sécurité
      • Documentation
  • Nous Connaître
    • Qui est 2ndQuadrant?
    • 2ndQuadrant: la Passion pour PostgreSQL
    • Actualités
    • Carrières
  • Blog
  • Installateurs
  • Menu Menu
Vous êtes ici : Accueil1 / Products2 / omniDB

OmniDB

Open Source Tool For PostgreSQL Database Management

OmniDB is an interactive and powerful, yet lightweight, browser-based database management tool. OmniDB allows users to manage multiple databases in a unified workspace with a user-friendly and fast-performing interface.

OmniDB open source database management tool

Why choose OmniDB?

Despite its light design, OmniDB is a reliable and comprehensive web tool with many facilitating characteristics to easily add, edit and manage multiple databases. Among the most significant characteristics are:

  • A Light Web Tool. Runs in any browser, from any operating system.
  • Responsive Interface. All available functions are displayed on a single page.
  • Simplified Editing. Easy to add and remove connections.
  • Secure. Multi-user support with encrypted personal information.
  • Interactive Tables. All functionalities use interactive tables, allowing to copy and paste blocks.
  • Smart SQL Editor. Contextual SQL code completion.
  • Unlimited access. It can be accessed by several computers and multiple users.
  • Tabbed SQL Editor. Easy to add, rename or delete editor tabs.

OmniDB Features

OmniDB gives you all the necessary features to add, edit and manage data in a unified workspace. It is capable of connecting and identifying main structures such as tables, keys, indexes and constraints.  Some of its most prominent features are listed below:

  • Easy to manage. The structure of your database is shown as an interactive tree. Each node’s context menu contains access to every available action. The user can easily switch between database connections by picking from a simple dropdown menu.
  • Create and edit tables easily. As a result of a powerful interface and extended editing capabilities, OmniDB allows you to manage and edit existing tables and create new ones easily. It also allows you to add & edit various table attributes like columns and foreign keys etc.
  • Data Management. It is possible to add, edit and remove table records, depending on the table’s characteristics.
  • SQL Editing.  OmniDB contains an interactive and customizable SQL editor, featuring syntax highlighting and SQL code completion for tables and subqueries.
  • Parallel Execution of Queries. OmniDB is powered by the WebSocket technology, enabling you to execute multiple queries in parallel.
  • Table Relation Graphs. With a single click you can see all tables and their relations, as well as a complete ER diagram.
  • Basic support for Oracle databases. OmniDB allows users to manage, connect, and interact with Oracle databases.
  • Basic support for MySQL and MariaDB. Users can manage, connect, and interact with MySQL 5.6/5.7 and MariaDB 10.1/10.2 databases using the same features available for Oracle databases.
  • Support for BDR 3.0. OmniDB manages BDR groups, allowing the user to view/add/remove nodes from groups and perform all tasks in every node.
  • Support for Plugins. Developers and users can add and share new features. Users can develop plugins in order to customize OmniDB to meet specific needs.
  • Support to Foreign Data Wrappers, Foreign Servers, User Mappings and Foreign Tables for PostgreSQL databases.  OmniDB can configure PostgreSQL to connect to Oracle, MySQL, Firebird, SQLite, SQL Server databases, and CSV files.
  • Support for PostgreSQL 11. Tables, functions and stored procedures can be managed in the Console Tab and in the Tree View. OmniDB debugger now works with PostgreSQL 11 functions and procedures.

Where to find OmniDB

OmniDB 2 is completely written in Python and designed to provide a user-friendly interface for your PostgreSQL database. Download is available here and installation instructions are available here.

OmniDB 2.14 Released – February 14, 2019

You can download OmniDB 2.14 here and go through the release notes here.

Why 2ndQuadrant?

2ndQuadrant provides PostgreSQL solutions for the Enterprise. Our support engineers have over 100 years of combined code contributions to the PostgreSQL project, making us the only company to contribute enterprise features to all of the last 13 releases.

This is paired with 17+ years of hands-on experience through client engagements and allows us to integrate customized solutions with our customers – making 2ndQuadrant the Gold Standard for PostgreSQL products & services.

To request more information about OmniDB  and other 2ndQuadrant supported products, please complete the contact form below and we will have someone contact you as soon as possible!

Get in touch with us!

  • Twitter
  • Linkedin
  • Facebook
  • Youtube
  • Mail

Support & Services

24/7 Production Support

Developer Support

Remote DBA for PostgreSQL

PostgreSQL Database Monitoring

PostgreSQL Health Check

PostgreSQL Performance Tuning

Database Security Audit

Upgrade PostgreSQL

PostgreSQL Migration Assessment

Migrate from Oracle to PostgreSQL

Products

HA Postgres Clusters

Postgres-BDR®

2ndQPostgres

pglogical

repmgr

Barman

Postgres Cloud Manager

SQL Firewall

Postgres-XL

OmniDB

Postgres Installer

2UDA

Postgres Learning Center

Introducing Postgres

Blog

Webinars

Books

Videos

Training

Case Studies

Events

About Us

About 2ndQuadrant

What does 2ndQuadrant Mean?

News

Careers 

Team Profile

© 2ndQuadrant Ltd. All rights reserved | Privacy Policy
  • Twitter
  • LinkedIn
  • Facebook
  • Youtube
  • Mail
Faire défiler vers le haut
×