PSQL Query Execute

v 19.0 Third Party 68

Versions

You bought this module and need support? Click here!

Availability	Odoo Online Odoo.sh On Premise
Odoo Apps Dependencies	Discuss (mail)
Lines of code	225
Technical Name	`sdlc_psql_query_execute`
License	LGPL-3
Website	https://sdlccorp.com

Versions

17.0 18.0 19.0

PSQL Query Tool for Odoo 19

Run PostgreSQL Queries
Inside Odoo.

Debug data, validate records, and build ad-hoc reports without leaving the backend, with SELECT-only safety, formatted result tables, and one-click XLSX export.

SELECT

Only, safe by design

1‑Click

XLSX Export

Zero

Configuration

Odoo 19

Built & Tested

LGPL‑3

Open License

A lightweight technical console for the people who actually query the database.

	Run raw SELECT statements from Settings > Technical
	Non-SELECT statements blocked to protect your data
	Results in a scrollable, styled HTML table
	Named, saved records you can re-run any time

psql.query

                        SELECT id, name, email

                        FROM res_partner

                        WHERE customer_rank > 0

                        LIMIT 3;

id	name	email
7	Azure Interior	azure@ex.com
9	Deco Addict	deco@ex.com
14	Gemini Furn.	gemini@ex.com

Export XLSX

Overview Features How It Works Screenshots Who It's For FAQ Support Contact

What is PSQL Query Execute?

PSQL Query Execute is a technical utility module for Odoo that lets system administrators run PostgreSQL SELECT queries directly from the Odoo user interface. It provides a simple, secure, and convenient way to query database tables without leaving the backend, complete with formatted HTML result tables and one-click XLSX export.

Whether you need to quickly inspect data, validate records, debug issues, or generate ad-hoc reports, this module gives technical users instant access to raw database results inside a clean, integrated Odoo interface.

Execute SELECT HTML Result Table XLSX Export SELECT-Only Guard Scrollable Results Error Handling Zero Config Save & Reuse Queries

PSQL Query Execute banner - Run PostgreSQL queries from the Odoo interface

Core Capabilities

What Makes This Module Powerful

Three essential capabilities for database-level insight from inside Odoo.

Execute SELECT Queries

Run raw PostgreSQL SELECT queries directly from the Odoo backend with a single click. No external tools needed.

Formatted HTML Results

View results in a styled table with sky-blue headers, alternating row colors, and scrollable layout for wide data.

One-Click XLSX Export

Export results to a formatted Excel file with Report Date, Company Name, and styled headers.

Full Feature Set

Everything Under the Hood

Every feature designed for fast, safe, and convenient database inspection.

Menu Access & Navigation

Accessible via Settings > Technical > PSQL Query. Fully integrated into the Odoo backend with no extra setup.

Query Name & Organization

Label and save each query with a dedicated name field for better management and quick re-execution.

SQL Query Input

Dedicated text area for writing raw PostgreSQL SELECT statements with full query flexibility.

Execute / Refresh

Run or re-run queries instantly with a single click. Results refresh immediately without a page reload.

Styled Result Table

Formatted HTML table with sky-blue headers, alternating rows, and horizontal/vertical scrolling for wide datasets.

XLSX Export with Branding

Export to Excel with Report Date, Company Name, styled column headers, and alternating row colors.

SELECT-Only Safety & Error Handling

Non-SELECT statements are blocked automatically to protect your data. Invalid queries, SQL syntax errors, and missing tables raise a clear Validation Error dialog with a descriptive message, so users know exactly what went wrong.

Quick Start

How It Works in 4 Simple Steps

From install to results in under a minute. No configuration required.

Navigate

Go to Settings > Technical > PSQL Query

Write Query

Enter a name and write your SELECT statement

Execute

Click Execute/Refresh to run instantly

Export

Click XLSX to download the Excel report

Screenshots

See It in Action

Real screens from menu access to XLSX export and error handling.

Access PSQL Query from the Settings > Technical menu

Query form view. Enter a Query Name, write your SQL, and click Execute/Refresh

Query entered. The example select * from res_partner limit 10 is ready for execution

Click Execute/Refresh to run the SQL query and fetch results from the database

Formatted HTML results with sky-blue headers, alternating row colors, and horizontal scrolling

Click the XLSX button to download query output as a professionally formatted Excel file

XLSX report in Excel. It includes the Report Date, Company Name, styled headers, and alternating row colors

Error handling. A Validation Error dialog shows a descriptive SQL error message

Built For

Who Is This Module For?

System Admins

Inspect tables, validate records, and debug data issues without leaving Odoo.

Developers

Test queries, verify data integrity, and run quick checks during development.

Consultants

Generate ad-hoc reports and investigate client data from the backend.

Odoo Partners

Give clients a safe, integrated tool for database inspection without external access.

Works Out of the Box with Zero Configuration

Install the module with no settings to configure

Navigate to Settings > Technical > PSQL Query

Create a new record, give it a name, and write your SELECT query

Click Execute/Refresh to run the query and view results

Click XLSX to download results as a formatted Excel file

FAQ

Frequently Asked Questions

What type of queries can I run?

Only SELECT queries are supported. INSERT, UPDATE, DELETE, and DDL statements are blocked for safety.

Is any configuration needed?

No. It works immediately after installation. Just go to Settings > Technical > PSQL Query.

Can I export results to Excel?

Yes. Click the XLSX button to download a formatted Excel file with Report Date, Company Name, and styled headers.

What if my query has an error?

A Validation Error dialog shows the exact SQL error message so you can quickly identify and fix the issue.

Can I save and reuse queries?

Yes. Each query is saved as a named record, so you can go back to any saved query, re-execute it, or modify it anytime.

Which Odoo version is supported?

This module is built and tested for Odoo 19 and follows Odoo-native design patterns and workflows.

Support & Updates

Free & Fully Supported

Open-source under LGPL-3, with ongoing bug fixes, version updates, and responsive support.

Promise 01

Free Bug Fixes

Any bugs found will be fixed free of charge for the lifetime of your installation.

Promise 02

Version Updates

Receive future updates and compatibility patches as new Odoo versions are released.

Promise 03

Dedicated Support

Reach our technical team via Email, Phone, or WhatsApp for any questions.

Need Help? We're Here.

Have a question, found an issue, or want to share feedback? We respond fast via Email, Phone, or WhatsApp.

Phone

+1 415-594-0097

+91 89209 44210

sales@sdlccorp.com

Built by SDLC Corp

sdlccorp.com

Version 19.0.1.0.0

Please log in to comment on this module

The author can leave a single reply to each comment.
This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
If you want to start a discussion with the author, please use the developer contact information. They can usually be found in the description.

Ratings
Discuss

gavinguo

on 5/11/26, 3:46 AM