# The Easiest Way to Manage Databases In Ignition: New Database Editor

**URL:** <https://forum.inductiveautomation.com/t/the-easiest-way-to-manage-databases-in-ignition-new-database-editor/14551>\
**Category:** Ignition\
**Created:** [June 19, 2017, 1:32am UTC](https://forum.inductiveautomation.com/t/the-easiest-way-to-manage-databases-in-ignition-new-database-editor/14551 "2017-06-19T01:32:33Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![nmudge](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nmudge/32/3394_2.png) [@nmudge](https://forum.inductiveautomation.com/u/nmudge)\
**Post date:** [June 19, 2017, 1:32am UTC](https://forum.inductiveautomation.com/t/the-easiest-way-to-manage-databases-in-ignition-new-database-editor/14551/1 "2017-06-19T01:32:33Z")

</div>

The Database Editor is a free Ignition project.

It is a graphical user interface that makes the following things easy:

1. View and query database tables.
2. Edit table cells.
3. Insert and remove rows.
4. Create new database tables.
5. Alter existing database tables, including renaming tables, renaming columns, adding and deleting columns, changing the order of columns, changing the data type of columns, adding indexes, removing indexes and editing various settings on columns such as default values and auto increment.
6. Delete database tables.

Check out the short video demo here: [http://www.perfectabstractions.com/database-editor.html](http://www.perfectabstractions.com/database-editor.html)

This image shows the **SQL Data Editor** tab.

 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/9/96b996894fb6ea55514494e65758c9338a21cea8.png)

This image shows the **Table Editor** tab:

 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/2/2d1a492d2b05ab0200053bf9273cc13b981f12e9.png)

Find out more and get it from this webpage: [http://www.perfectabstractions.com/database-editor.html](http://www.perfectabstractions.com/database-editor.html)

---

<div class="post-metadata">

**Author:** ![zackscriven](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/zackscriven/32/7213_2.png) [@zackscriven](https://forum.inductiveautomation.com/u/zackscriven)\
**Post date:** [June 19, 2017, 4:48pm UTC](https://forum.inductiveautomation.com/t/the-easiest-way-to-manage-databases-in-ignition-new-database-editor/14551/2 "2017-06-19T16:48:26Z")

</div>

Nice job! that is wicked.

---

<div class="post-metadata">

**Author:** ![nmudge](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nmudge/32/3394_2.png) [@nmudge](https://forum.inductiveautomation.com/u/nmudge)\
**Post date:** [June 19, 2017, 5:41pm UTC](https://forum.inductiveautomation.com/t/the-easiest-way-to-manage-databases-in-ignition-new-database-editor/14551/3 "2017-06-19T17:41:39Z")

</div>

Thanks Zack! I always love your input.