dbAdmin Icon

dbAdmin

By Serg Shlokov (sergant210)

dbAdmin is a map table that shows corresponding MODX object classes for system tables.

Base features:
  • browse tables;
  • truncate, remove and rename tables;
  • export entire database or selected tables to text file;
  • filter by table name or class name;
  • execute sql queries.

Permissions

To work you need the following permissions (except the admin with sudo):

  • tables_list — Allow to view a list of tables.
  • table_view — Table view permission.
  • table_save — Table save permission.
  • table_truncate — Truncate permission (truncate table).
  • table_remove — Remove permission (drop table).
  • table_export — Allow to export a table.
  • sql_query_execute — Allow to execute sql queries.

Short video.

More information on Github.

Serg Shlokov


New in dbAdmin 1.1.3

1.1.3-pl

==============

- Added the horizontal scrolling for a table window.

- Added output type - varexport or printr.

- Added syntax highlighting for sql.

- Now, instead of the "query error", a full description of the error is displayed.

1.1.2-pl

==============

- Changed file name format of database backup to "databasedatetime.sql". For example, "modx20160317090155.sql".

1.1.1-pl

==============

- Fixed some errors.

- Add support of PHP 5.3.

1.1.0-pl

==============

- Added the ability to edit the selected cell in tables with a class or remove entire row.

- Auto-update the list of tables.

- Added Magic button to define a class for table.

- Added 'Select from' button to the tables grid that adds 'Select from' script for selected table to the SQL query editor.

1.0.1-pl

==============

- Fixed the error of checking update (was wrong package name).

- Added autocreation a folder for export operation.

- Added the table access_namespace for MODX 2.4.0.

1.0.0-pl

==============

- Fixed the error of renaming table.

- Auto synchronization instead of the button.

- Added a "need update" marker (by experiment).

1.0.0-beta

==============

- Initial release

More

Information

Released
June 30, 2017
Supported Versions
2.3 – Current
Downloads
5,498
License
GPLv2
Website

More from Serg Shlokov

modalConsole

It's a modal console for PHP.

View
siteStatistics

Page and user visits statistics

View
controlErrorLog

Closing the window by clicking on the icon

View
AdminTools

Adds some features for MODX administrators and developers.

View