VJ Database Tool

VJ Database Tool

TOP FEATURES

Multiple database types support
VJ Database Tool supports: MySQL, PostgreSQL, SQLite, Oracle, MS SQL.

Easily manage databases
Manages databases, tables and fields simply through your Joomla! administration panel.

All-in-one database tool
This tool includes everything you need for an advanced database management through your Joomla! administration panel.



Other Notable Features


Create, remove, edit databases, tables, fields
Creates dumps
Multilingual
Connect to a database server with username and password
Select an existing database or create a new one
List fields, indexes, foreign keys, and triggers of tables
Change name, engine, collation, auto-increment, and table comments
Alter name, type, collation, comment and default values of columns
Add and drop tables and columns
Create, alter, drop and search by indexes including fulltext
Create, alter, drop and link lists by foreign keys
Create, alter, drop and select from views
Create, alter, drop and call stored procedures and functions
Create, alter and drop triggers
List data in tables with search, aggregate, sort and limit results
Insert new records, update and delete the existing ones
Supports all data types, blobs through file transfer
Execute any SQL command from a text field or a file
Export table structure, data, views, routines, databases to SQL or CSV
Print database schema connected by foreign keys
Show processes and kill them
Display users and rights and change them
Display variables with links to documentation
Manage events and table partitions (MySQL 5.1)
Schemas, sequences, user types (PostgreSQL)
This is open-source software under GPL license