Execute PSQL Query with On-Screen HTML Preview | Raw PostgreSQL Query Visualization

Direct SQL Execution, Live Data Preview, and UI Result Rendering in Odoo

Description:

This module empowers database administrators and technical users to execute raw PostgreSQL queries and instantly visualize the output directly within a highly polished Odoo UI dashboard. Building upon the base SQL execution framework, this extension introduces a powerful live HTML preview feature. Instead of exclusively relying on Excel exports, authorized users can now write SELECT statements in a syntax-highlighted editor, hit the "Preview" button, and instantly view the structured data results rendered as a clean, scrollable, and responsive data table entirely inside the Odoo interface.

Purpose of the Module:

The purpose of this module is to provide technical teams with a rapid, secure, and all-in-one visualization workspace to interact directly with the Odoo PostgreSQL database without leaving the application or constantly downloading files. By rendering query results live on the screen, users can quickly extract custom data, validate data integrity, test complex table joins, and troubleshoot technical issues instantly. This eliminates the need for external database management tools like pgAdmin and drastically reduces the turnaround time for data analysis.

Main Features

• Live HTML Data Preview:
  • Instantly render the results of your SELECT queries as a clean, on-screen data table directly within the Odoo form, eliminating the absolute need to download external files for quick data checks.
• Responsive Table Rendering:
  • Query outputs are automatically formatted into a dynamic table layout that intelligently stretches to fit column data. It includes built-in horizontal and vertical scrolling for massive datasets, ensuring your UI remains clean and unbroken.
• Intelligent Query Validation:
  • Applies a strict safety layer by exclusively allowing SELECT queries to be run through the preview engine, automatically blocking and rolling back unsupported data manipulation attempts.
• Detailed Visuals for Better Understanding:
  • Explore the screenshots below to see the SQL Query Previewer in action. You will see the responsive HTML data table rendering live data flawlessly.

Scope of the Module

The SQL Query Preview module extends Odoo's technical capabilities by incorporating deep developer analytics, direct database interaction tools, and live data visualization into the system settings.

Module Scope Includes:

• Information Visibility:
  • Display structured live data outputs, impacted record metrics, and syntax error messages inside an isolated preview interface.
• Technical Support:
  • Enable developers to rapidly analyze complex database relationships and validate custom module data without relying on external software.
• Database Control:
  • Help prevent accidental data loss or corruption by strictly limiting the "Preview" functionality to read-only SELECT queries.

Business Benefits:

• Efficiency:
  • Drastically reduced data validation time by viewing query outputs instantly on the screen instead of repetitively downloading and opening Excel sheets.
• Optimization:
  • Cleaner system insight and faster debugging without deploying heavy third-party monitoring utilities or sharing direct backend server credentials.
• Accuracy:
  • Immediate visual feedback allows developers and admins to refine and perfect their SQL logic on the fly.

Supported Business Verticals / Industries:

The SQL Query Preview Manager is suitable for organizations of all sizes and industries that use Odoo and require direct database access for reporting, analysis, troubleshooting, data validation, administration, or system maintenance. Whether you are managing sales, inventory, accounting, manufacturing, CRM, HR, projects, or any other Odoo application, this module provides a powerful, instant way to execute SQL queries and analyze data directly on your screen.

Videos:

• Video 1: https://probuseappdemo.com/probuse_apps/psql_query_run_ui_extend_preview/1760
• Video 2: https://probuseappdemo.com/probuse_apps/psql_query_run_ui_extend_preview/1761

Example of Performing Sales Profitability Query and Preview

Navigate to the "Daily Logs" tab in the top menu and select "My Daily Logs" to access and manage your personal construction site reports.

Live Data Rendering in Preview Output

The executed query results are instantly formatted into a clean, scrollable HTML table directly on your screen, allowing for rapid visual data validation without downloading any files.

Example of Performing Product Sales Velocity Query and Preview

The user can write or select an inventory query template and click the PREVIEW button to instantly generate the live data inside the Preview Output block.

Live Data Rendering in Preview Output

The executed inventory and sales data is instantly formatted into a clean, scrollable HTML table directly on your screen, allowing for rapid visual data validation without downloading any files.