Database Administration

The dba module provides Drupal administrators with direct access to their Drupal database tables from within the standard Drupal user interface. It is possible to execute scripts to create and alter tables, to backup one or more tables, to view/edit/delete data within tables, and to emtpy or drop tables. If using MySQL, it is also possible to check and repair tables.

Screenshots available.

WARNING: If a user is granted (or manages to aquire) 'dba adminster database' permissions, they are able to directly alter the database. At minimum, they are able to modify data, and possibly to drop tables. Depending on how you have defined your database permissions, the user may also be able to modify other databases unrelated to your Drupal installation. Use at your own risk!

UPDATE 2006-11-19: This module has finally been ported to the 4.7.x Drupal core API!

Features:
--------
- works with both MySQL and PostgreSQL
- ability to execute sql scripts and see the resulting output (ie, create/alter/update tables)
- overview listing of all tables and total row counts for each
- ability to backup one or more tables from active database
- ability to view table data
- ability to describe table
- ability to empty (delete) all data from one or more tables at a time
- ability to drop one or more tables at a time
- ability to edit a specific row (using simple form)
- ability to delete a specific row
- in MySQL, ability to check and repair one or more tables at a time
- two permissions: 'dba view database' and 'dba administer database'

Releases

Official releases	Date	Size	Links	Status
4.7.x-1.2	2007-Apr-11	21.32 KB	Download · Release notes	Recommended for 4.7.x

Development snapshots	Date	Size	Links	Status
5.x-1.x-dev	2008-Dec-11	24.19 KB	Download · Release notes	Development snapshot
4.7.x-1.x-dev	2008-Feb-20	23.89 KB	Download · Release notes	Development snapshot