Database Tool is a Publii plugin that lets you browse and edit your site's internal SQLite database directly from the plugin settings view, and freeze post and page dates.
- Browse posts, pages, tags, and additional data from the plugin settings view
- Edit post/page fields, tags, and additional data, then export the modified database
- Freeze a post's or page's created and modified dates for rendering
- Run raw SELECT and write queries against the loaded database
- Download a backup of the original database before making changes
Publii 0.46.0 or newer. Nothing else, the plugin is fully self-contained and works offline.
- Download the release ZIP.
- Publii -> Tools -> Plugins -> Install plugin -> pick the ZIP.
- Enable the plugin for the site.
Open Plugins -> Database Tool -> settings icon. The tool loads the current site's database.
Use the tabs to browse Posts, Pages, Tags, Additional Data, or run a raw query.
Expand a row to edit fields or freeze its dates. Edits are made in memory, click Export Modified DB, replace input/db.sqlite in your site folder with the exported file, and restart Publii to apply.
Save Date Overrides stores date freezes in the plugin config. These are applied automatically at each site render, no database export needed.
Feel free to fork this project or contribute a PR.
Build instructions can be found in the developer readme DEV.md.
This project is licensed under the GPLv3+. See LICENSE file for details.
The plugin class (main.js) is self-contained plain JavaScript with no dependencies. The
plugin settings view (options/index.html) bundles two libraries under options/vendor/.
Full license texts under Third Party Licenses/:
- sql.js - MIT License - reads/edits the site SQLite database. Third Party Licenses/sql.js
- flatpickr - MIT License - date/time picker. Third Party Licenses/flatpickr
This project was developed by InPoint Automation Sp. z o.o. https://inpointautomation.com/
Thanks to the Publii project for the CMS and plugin API.
See CHANGELOG.md for the full version history.