OmegaRIP database software about this site contact me

OmegaRIP

OmegaRIP is an application that connects to any supported database (SQL Server, MySQL, Firebird, PostgreSQL, SQLite, Access, etc) and allows you to decipher the structure of that database.

OmegaRip aims to aid developers who write reports or create interfaces to third-party databases by providing a robust automated query tool, a manual SQL query tool, database info (Indexes, Keys, Stored Procedures, etc), and a graphical relationship visualizer.

It was concieved as a quick (and dirty) solution to a problem that plagues me almost every day:

Highslide JS
Select existing database server connection (MS SQL Server, MySQL, SQLite, PostgreSQL, MS Access, Firebird SQL, and more!) Close   
Highslide JS
Visualize relationships: Interesting Tables diagram automatically links tables on foreign keys and allows you to build a graphical diagram of potentially linked columns. Close   

"Hey, can you pull stuff from this database that:"
  • You did not create
  • Drives an application that you are not familiar with (and likely do not understand)
  • Has structures that are extremely large (1000's of tables)
  • Has structures that are incomprehensibly named (purposefully obfuscated or just poor adherance to known naming convnetions)
  • Has structures that are not normalized, constrained, or do not otherwise follow best practices
  • Contains data that you do not understand (ie: financial/payroll/banking data, medical/psychiatric data, statistical data, etc)
  • Exposes no applicable messaging system (ie: HL7)
  • Kinda blows.

Armed with OmegaRIP, the answer is, "YES"

OmegaRIP can tell you exactly where a piece of data resides and give you a head-start as you try to figure out how tables are linked.

 

Download

OmegaRIP is currently in beta testing and is available for the Windows platform only. It is built/compiled/tested on Windows XP Pro SP3.

Download Windows Setup Package: OmegaRIP-0-9-3.msi
 

OmegaRIP is free, but if you find it useful, please buy one of my albums! You'll get the satisfaction of having a helpful database utility AND some electronic music to accompany your day's databasing activities.

Disclaimer: OmegaRIP was built and tested on a single Windows XP system with a small handful of database servers. I cannot guarantee that the app will run on your particular system or perform as expected.

 

Screenshots

Highslide JS
Select existing database server connection Close   
Highslide JS
Performing a simple text query with one search term Close   
Highslide JS
Search results showing only tables with relevant data Close   
Highslide JS
Using the Table/Column finder to look for any structure that contains 'schedule' in it's name Close   
Highslide JS
Manual SQL Executor Close   
Highslide JS
Visualize relationships: Interesting Tables diagram automatically links tables on foreign keys and allows you to build a graphical diagram of potentially linked columns. Close   
Highslide JS
Database Information Close   
Highslide JS
Double Click stored procedures to view code. Close   
Highslide JS
Searching for records that contain dates in a range... Close   
Highslide JS
Exported Interesting Table Diagram (PNG, GIF, BMP, or JPEG) Close   

 

Why? (+ click to expand)

How? (+ click to expand)

Additional Goodies (+ click to expand)

Version Notes: (+ click to expand)