SQL Query Manager | Execute Raw PostgreSQL Queries, Save Results & Export to Excel

Raw SQL Query Executor | PostgreSQL Query Management, Saved Queries & Excel Export

Description:

This module empowers database administrators and technical users to execute raw PostgreSQL queries directly from a highly polished Odoo UI dashboard. By default, running direct SQL queries requires backend server access or external database management tools like pgAdmin. With this module, authorized users can write code in a fully featured syntax-highlighted editor, securely execute statements, view results in a dark-mode developer terminal, and manage a reusable library of saved query templates entirely within the Odoo interface.

Purpose of the Module:

The purpose of this module is to provide technical teams with a secure, all-in-one workspace to interact directly with the Odoo PostgreSQL database without leaving the application. By integrating a backend query generator with modern developer tools, users can extract custom data, perform administrative updates, and track query history effortlessly.

This helps organizations troubleshoot technical issues instantly, extract complex data on the fly, optimize developer speed via point-and-click copy-paste mapping, and maintain a clear audit trail of all manual database interventions.

Main Features

• Dual-Pane Code Workspace:
  • Features a modern side-by-side developer layout separating your input editor directly from your output visualization window for a seamless coding experience.
• Syntax-Highlighted Editor:
  • Replaces plain text entry with an integrated code widget displaying structured lines, distinct keyword highlights, and auto-indentation behaviors.
• Styled Developer Terminal:
  • Displays execution feedback, structural exception logs, and performance metrics inside a custom dark console viewport featuring distinct cyan monospace fonts
• Saved Query Library:
  • Easily load saved queries from a dropdown, or save your currently written query as a brand-new saved query directly from the execution screen without navigating away.
• Smart Clipboard Assistants & SQL Formatting:
  • Look up specific Odoo Model and Field names with native copy-to-clipboard widgets. Model names are automatically formatted with underscores (e.g., sale_order instead of sale.order) for instant, error-free SQL copy-pasting.
• Instant Excel Export:
  • Automatically generates and downloads a cleanly formatted Excel (.xls) file containing the exact output of your queries, avoiding manual data extraction.
• Execution Confirmation Wizard:
  • Applies a strict safety layer by prompting a confirmation popup before any query is processed, helping to prevent accidental data manipulation.
• Error Handling & Rollback:
  • Intelligently catches database exceptions and syntax errors, displaying the exact PostgreSQL error message in the terminal while rolling back the transaction to prevent system crashes.
• Query Result Logs:
  • Tracks every executed query automatically in a dedicated history log. It records the query string, execution timestamp, the user who ran it, and the success or error message.
• Strict Access Control:
  • Secures the entire tool behind a dedicated "Run SQL Query" user group, ensuring that only authorized administrators and developers can access the workspace.
• Detailed Visuals for Better Understanding:
  • Explore the screenshots below to see the SQL Query Generator in action. You will see the side-by-side developer workspace, the dark terminal output, and the clean saved query management setup.

Scope of the Module

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

Module Scope Includes:

• Information Visibility:
  • Display structured data outputs, impacted record metrics, and syntax error messages inside an isolated terminal interface.
  • Show technical model tables and field properties side-by-side using dedicated clipboard-ready tab panels.
  • Track historical data logs across a localized model storage archive.
• Technical Support:
  • Enable developers to analyze complex database relationships without relying on external software.
  • Speed up system debugging, custom module testing, and data migrations with reusable saved queries.
• Database Control:
  • Protect against typing errors by enforcing clear, copy-pasteable data definitions.
  • Reduce manual data extraction time by downloading query output straight to Excel.
  • Help prevent accidental data loss or corruption through mandatory confirmation prompts and transaction rollbacks.

Business Benefits:

• Efficiency:
  • Drastically reduced manual lookup time when cross-referencing field types and naming styles.
  • Elimination of repetitive typing via instant query saving and loading.
  • More informed and rapid responses to critical support tickets.
• Optimization:
  • Cleaner system insight without deploying heavy third-party monitoring utilities.
  • Better compliance and auditing through centralized execution logs.

Supported Business Verticals / Industries:

The SQL Query 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 way to execute SQL queries, analyze data, and export results.

User Access Rights Configuration for SQL Queries

Enable the "Run SQL Query" checkbox under the user's access rights to grant them permission to view the menu and execute database queries.

Navigate to SQL Query Runner Menu

Open the Settings app and navigate to the Technical menu to access the SQL Query Runner, allowing you to execute queries, manage saved queries, and view execution logs.

Execute Query Menu Access

Select the "Execute Query" menu option to land directly on the main query execution workspace where you can write and run your SQL statements.

Default Query Execution Workspace

Access the main, empty execution dashboard where you can begin writing new SQL statements, searching for database models, and viewing your terminal output.

Example 1: Query Construction & Execution

Database Table and Column Lookup

Search for specific Odoo models and fields to easily copy and paste their technical database names directly into your SQL query editor.

Manual Query Construction & Execution

Build your custom SQL query from scratch in the editor using the bottom lookup tool for reference, then click the "Run" button to execute your code.

Terminal Output & Instant Export

Review the processed record count and success message directly in the dark terminal window, and click the generated link to download your file.

Analyze Data in Spreadsheet

Open the downloaded Excel file to instantly view your formatted SQL query output and analyze the extracted database metrics.

Save Custom Query Templates

Enter a clear title into the "Save As New Query" field and click the green "Save Query" button to store your custom code for future use.

Success Acknowledgement Notification

Receive an immediate visual confirmation prompt at the top right of your screen ensuring your new query template has been successfully saved to the database.

Access Saved Queries Menu

Navigate to the Technical settings and select the "Saved Queries" menu to access your complete library of stored SQL templates.

View Saved Queries Library

Browse through your organized list of saved SQL queries to quickly find the exact template you need based on its title and description.

Manage Saved Query Details

Open the form view of any saved query to review its underlying SQL code, utilize the built-in lookup tools, or update its descriptive notes.

Example 2: Load Query & Execution

Load Saved Query Templates

Select a previously saved query template from the dropdown to automatically populate the SQL editor block for quick execution.

Execute the Loaded Query

Once the template populates the SQL editor, review your query and click the "Run" button at the top left to execute the query against the database.

Query Execution Confirmation Wizard

Safely confirm your action via the popup prompt before the system processes the SQL statement to prevent accidental database changes.

Terminal Feedback and Instant Excel Export

Check the developer terminal for execution success and processed record counts, then click the generated document link to download your results.

Review Exported Data in Spreadsheet

Open the downloaded .xls file to immediately view and analyze your extracted PostgreSQL database records in a cleanly formatted table.

Execute the Loaded Query

Once the template populates the SQL editor, review your query and click the "Run" button at the top left to execute the query against the database.

Query Execution Confirmation Wizard

Safely confirm your action via the popup prompt before the system processes the SQL statement to prevent accidental database changes.

Terminal Feedback and Instant Excel Export

Check the developer terminal for execution success and processed record counts, then click the generated document link to download your results.

Review Exported Data in Spreadsheet

Open the downloaded .xls file to immediately view and analyze your extracted PostgreSQL database records in a cleanly formatted table.

Performing Direct Database Deletions

Performing Direct Database Insertions

Performing Direct Database Updates

Access Query Execution Logs

Navigate to the Technical settings and select the "Query Logs" menu to review a complete history of all executed database queries.

Query History List View

View a comprehensive list of all past query executions, including the exact SQL statements, execution timestamps, and the specific user who ran them.

Detailed Query Log Record

Open any individual log entry in form view to inspect the full SQL statement, review the terminal result message, and audit the execution details.