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.

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.

Navigate

Go to Settings > Technical > PSQL Query

Write Query

Enter a name and write your SELECT statement

Execute

Click Execute/Refresh to run the query instantly

Export

Click XLSX to download formatted Excel report

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.

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. Works immediately after installation. Just navigate 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 record with a name. 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. It follows Odoo-native design patterns and workflows.

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.

Odoo Customization

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

Odoo Implementation

Complete end-to-end Odoo setup, configuration, data migration, and 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 and zero downtime.

Email

Phone

WhatsApp