DBV


 DBV is an open source and PHP-powered application that can help us include databases in to the version control system we are using. Once installed, it tracks each schema/record change (tables, rows, columns, views, functions, etc.) and allows us to export a SQL file reflecting the change (to a folder we want). As this SQL file will also be committed with th version control system we are using, it’ll be received with other team members. DBV supports MySQL by default and has a simple interface to implement connectors for any other databases.

The single-file MongoDB admin app.

DbNinja is an advanced web-based application for MySQL database administration and development. It’s a must-have for those who wish to access their hosted servers remotely. DbNinja supports all the latest features including: triggers, events, views, stored routines and foreign keys; in addition it allows to import and backup data and MySQL object structures, manage users and much more.

SQLiteManager is a multilingual Web-based tool to manage SQLite databases. It features multiple management, creation, and connectivity, property and options management, table, data, and index manipulation.

It is a free (also open source) and web-based database service that doesn’t require any registration and can be used instantly. We simply send a POST request to store any data (with a unique prefix of our preference), can request or delete it anytime and responses comes in a JSON format. Also, like mentioned, OpenKeyval is open source. It is built with PHP and anyone can host their own instance.

phpMyAdmin is a free software tool written in PHP, intended to handle the administration of MySQL over the Web. phpMyAdmin supports a wide range of operations on MySQL, MariaDB and Drizzle.

Manage your databases over the web using a secure and intuitive interface with blazing fast performance.

 For Microsoft SQL Server database admins, there probably isn’t a better tool out there than Miscosoft’s freeware app (downloadable at $0 dollars on the Microsoft site), SQL Server Management Studio. SQL Server Management Studio has a GUI that Windows OS users will find straightforward, and it has an innovative feature called Object Explorer that lets you browse, select, and perform tasks on database objects. It’s the only tool you need for creating and administering Microsoft SQL Server databases.

 Navicat for MySQL

Navicat for MySQL is part of the family of cross-platform (Windows/Mac/Linux) relational database management tools created by PremiumSoft. It has a visual query builder for creating complex database queries in a snap, import/export/backup tools for your databases, a report builder for printing out db queries that the boss can understand, a task scheduling assistant for scheduled execution of jobs, and much more.

Navicat also produces front-ends for Oracle and PostgreSQL. Navicat products have aLite version (non-commercial) and a Premium version; check out the feature matrix to see the difference in features of both versions.

SQLyog


 SQLyog is a GUI administration tool for MySQL developed by Indian-based software company, Webyog. It comes in two flavors: Enterprise (with the price ranging from $99 to $999) and the pared down Free Community version; to see the differences, check out the feature comparison table. SQLyog’s list of features is outstanding and unfathomable – a top-notch tool for professional database admins.

TAGS :