Visual DB Gem Version

Visual DB is web utility to connect to local or remote MySQL instances and view & modify data. Visual DB is meant to be quick and easy to use, and reduce some potential for errors in user queries. Visual DB is a resource well suited for those just getting started with SQL syntax.

Screenshots

  • screenshot

Features

  • Download Tables as CSV
  • View/Create/Delete Databases
  • Connect to local or remote mySQL instances
  • Accessible via browser of your choice
  • SQL Query templates based on user input
  • Tables sortable by column header

Installation

To install the Ruby Gem (which is generally more stable, but several commits behind this repository):

gem install visual_db

To install this repo directory, simply clone assign appropriate permissions, and install necessary dependencies.

Dependencies

  • See Gemfile for dependencies
  • Developed and tested on Ruby 2.2, Mac OS 10.10, and MySQL 5.6.21

TODO

  • UI Work
  • More UI guided SQL query generation