django-sqlconsole 1.4.0

sql console is an app which allows for the execution of sql queries in the admin section of django.

Django SQL Console

Sqlconsole is a django app that allows for the execution of sql queries from the admin section of a django site. An appropriate use case is when you don't have access to the database especially in a production environment.

SqlConsole is really meant to be used for database read queries eg:

SELECT * FROM <some_table>

SELECT count(*) FROM <some_table>

SQL queries that modify (INSERT, UPDATE etc) data are not supported.

Install

pip install django-sqlconsole

Add the app to INSTALLED_APPS

INSTALLED_APPS = [
...
'sqlconsole'
]

SqlConsole will be included in the admin section with a history of executed queries.

Permissions will be required to execute queries sqlconsole.can_execute_query

Screenshot