|Version 4 (modified by mrjbq7, 4 years ago) (diff)|
Perform SQL queries on the Trac database
The TracSQL plugin adds a "SQL" tab to the trac project. Inside this tab SQL queries can be performed on the project database.
This plugin supports Trac installations with SQLite, MySQL, and PostgreSQL database backends (although the queries will need to be written differently according to which SQL database is being used).
See http://github.com/mrjbq7/tracsql for more details and the source code, or to report issues or request features.
It is configured in the trac.ini file by enabling and configuring:
[components] tracsql.* = enabled
The TRAC_ADMIN permission is used to control access to the query pages.
Some screenshots, showing a few of the features: