OmniDB is an open source browser-based app designed to access and manage many different Database Management systems, e.g. PostgreSQL, Oracle and MySQL.
The program is built with simplicity in mind, designed to be a fast and lightweight browser-based application. OmniDB is also powered by the WebSocket technology, allowing the user to execute multiple queries and procedures in multiple databases in multiple hosts in background.
OmniDB can run either as an App or via Browser, combining the flexibility needed for various access paths with a design that puts security first.
The original OmniDB project is no longer under active development. A separately maintained fork has revived the application with a rewritten Go backend and a Wails-based desktop interface, although it differs substantially from the software described in this entry.
Key Features
- 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.
- Easy database management:
- Tree view showing database structure.
- Simple form for table creation and editing:
- 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: Add, edit and remove records.
- SQL Editing:
- Full-featured SQL Editor with syntax highlighting.
- SQL code completion for table columns and subquery.
- SQL code completion with basic contextual information.
- Visualization of explain plan
- PL/pgSQL function debugger.
- Show PL/pgSQL debugging session statistics.
- Monitoring dashboard.
- Console Tab.
- SSH Console.
- Support for external tools available as installable plugins:
- pglogical.
- Postgres-BDR.
- Postgres-XL.
- Cross-platform support – runs under Linux, Mac OSX, and Windows.
Website: github.com/OmniDB/OmniDB
Support: Documentation
Developer: 2ndQuadrant Limited
License: MIT License
OmniDB is written in Python. Learn Python with our recommended free books and free tutorials.
Related Software
| MySQL Tools | |
|---|---|
| DBeaver | Universal database tool |
| phpMyAdmin | MySQL web administration tool |
| NocoDB | Build databases as spreadsheets |
| MySQL Workbench | Complete visual database design tool |
| mycli | Command line interface for MySQL, MariaDB, and Percona |
| gh-ost | GitHub's Online Schema Migrations for MySQL |
| Beekeeper Studio | Cross-platform SQL editor and database manager |
| usql | Command-line database client |
| sqlit | lazygit of SQL databases |
| Harlequin | Easy, fast, and beautiful database client for the terminal |
| DbGate | Database manager for MySQL, PostgreSQL, MongoDB |
| Percona Toolkit | Essential command-line utilities for MySQL |
| SQuirreL SQL Client | Graphical SQL client written in Java |
| Adminer | Full-featured tool for managing content in MySQL database |
| dblab | Interactive client for PostgreSQL, MySQL, SQLite3, and more |
| Antares | SQL client based on Electron.js and Vue.js |
| XtraBackup | Backup utility for MySQL |
| innotop | Real-time, advanced investigation tool |
| SQLCheck | Detects common SQL anti-patterns |
| Skeema | Manage MySQL and MariaDB schema changes |
| Sequeler | Native Linux SQL client built in Vala and Gtk |
| orchestrator | High availability and replication management tool |
| OmniDB | Collaborative environment For database management |
Read our verdict in the software roundup.
 LinuxLinks helps you discover the best free and open source software for Linux. Explore our extensive collection of recommended applications, including alternatives to popular proprietary software.We also publish software reviews, Linux tutorials, hardware reviews, free programming books and articles covering the wider open source community. Browse our Linux resources to discover more. Know a useful free and open source Linux application we haven't covered? Suggest a program for inclusion. Has your software been featured on LinuxLinks? Display one of our Featured on LinuxLinks badges on your website or GitHub README. |
Please read our Comment Policy before commenting.