Version 5 (modified by anonymous, 8 years ago) (diff)


Perform SQL queries on the Trac database


The TracSQL plugin adds a "SQL" tab to the trac project. Inside this tab, the plugin supports interacting with the project database.

Some features include:

  • perform queries on the project database
  • view results as raw or formatted (and hyper-linked) output
  • export result set in CSV
  • browse the database schema

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 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:

tracsql.* = enabled

The TRAC_ADMIN permission is used to control access to the query pages.


Some screenshots, showing a few of the features:

Recent Changes

8021 by mrjbq7 on 2010-05-28 04:34:53
New hack TracSqlPlugin, created by mrjbq7


Author: mrjbq7?
Maintainer: mrjbq7?

Attachments (3)

Download all attachments as: .zip