Odoo PSQL Query Execute

Run PostgreSQL Queries Directly from Odoo

Execute PostgreSQL queries without leaving Odoo. However, most tools require switching environments. Therefore, this module lets you run PSQL SELECT queries directly inside Odoo with speed and control.

Core Capabilities - What Makes This Odoo Module Powerful

Running database queries should be simple. However, most tools make the process complex. Therefore, PSQL Query Execute focuses on three core capabilities that solve real problems 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 beautifully styled table with sky blue headers, alternating row colors, and scrollable layout.

One-Click XLSX Export

Export query results to a professionally 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 organize saved queries 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 and syntax support.

Execute / Refresh

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

Styled Result Table

Formatted HTML table with sky blue headers, alternating row colors, 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 for professional output.

Error Handling & Validation

Descriptive error messages with Validation Error dialogs for invalid queries, SQL syntax errors, or missing tables. Clear feedback so users know exactly what went wrong.

How It Works - Execute Odoo PSQL Queries in 7 Simple Steps

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

Navigate to PSQL Query Tool

Start by accessing the module from Settings → Technical → PSQL Query. Therefore, you stay inside the Odoo environment.

Query Form View

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

Write Your SQL Query

Enter your query in the provided input area. In addition, you can assign a name for easy reference. However, only SELECT queries are supported. Therefore, your data remains safe and unchanged.

Execute the Query Instantly

Click Execute/Refresh to run your query. As a result, the system processes it immediately. Moreover, results appear without page reload. Therefore, your workflow stays fast and uninterrupted.

Export Results to XLSX

Once results are displayed, you can export them with one click. Therefore, reporting becomes simple.

XLSX Report

XLSX report opened in Excel — Report Date, Company Name, styled headers, and alternating row colors.

Error Handling

Error handling — Validation Error dialog with a descriptive SQL error message.

Built For - Who Should Use Odoo PSQL Query Execute?

PSQL Query Execute enables fast and secure PostgreSQL query execution inside Odoo, with direct database access and efficient workflow support for developers, DBAs, and admins.

System Admins

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

Developers

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

Consultants

Generate ad-hoc reports and investigate data for clients directly from the Odoo backend.

Odoo Partners

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

Zero Configuration - Works Out of the Box

Free Lifetime Support - Reliable Help When You Need It

We stand behind our module. Get free lifetime bug-fix support with every installation – no hidden charges, no expiry.

Free Bug Fixes

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

Free Version Updates

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

Dedicated Support

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

Our Services - Complete Odoo Solutions for Your Business

Managing Odoo systems requires more than just modules. However, many businesses struggle with setup, customization, and scaling. Therefore, we provide end-to-end Odoo services designed for performance, reliability, and growth.

Odoo Customization

Tailor Odoo modules and workflows to match your exact business requirements.

Odoo Implementation

Complete end-to-end Odoo setup, configuration, data migration, go-live support.

Odoo Support & Maintenance

Ongoing technical support, bug fixes, performance tuning, and maintenance plans.

Odoo Integration

Connect Odoo with third-party platforms, APIs, payment gateways, and external systems.

Hire Odoo Developer

Dedicated Odoo developers available for short-term or long-term project engagements.

Odoo Migration

Seamless migration from older Odoo versions or other ERPs with data integrity , zero downtime.

Need Help or Have Questions?

If you need help with setup, compatibility, customization, or have any questions, feel free to contact us.

Contact Us For

Everything You
Need to Know

Find clear answers to common questions so you can understand everything without any confusion or delay.

What type of queries can I run?

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

Can I export query results to Excel?

Yes, you can export results using the XLSX button. Therefore, downloading reports is quick and easy. Moreover,
exported files include:
Report date
Company name
Styled headers
As a result, your reports are ready for use without extra formatting.

What happens if my query has an error?

A validation error message appears instantly. Therefore, you can identify the exact SQL issue.

Can I save and reuse queries?

Yes, each query can be saved with a name. Therefore, you can reuse it anytime. In addition, you can modify or re-run saved queries easily. As a result, repetitive work is reduced.

Which Odoo version is supported?

This module is built and tested for Odoo 19. Therefore, it follows native Odoo design patterns and workflows.