| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
Discuss (mail)
|
| Lines of code | 1470 |
| Technical Name |
pg_data_ops |
| License | See License tab |
| Website | https://www.linkedin.com/in/dfunn1k/ |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
Discuss (mail)
|
| Lines of code | 1470 |
| Technical Name |
pg_data_ops |
| License | See License tab |
| Website | https://www.linkedin.com/in/dfunn1k/ |
PG Data Ops
Controlled PostgreSQL data operations for Odoo, built for technical users who need visibility, guardrails, and an audit trail.
Execute SQL declarations from Odoo with security, rollback previews, and export-ready results.
PG Data Ops gives administrators and technical teams a dedicated workspace for controlled PostgreSQL operations. Query data, review changes, run safe executions, inspect returned rows, and keep every execution traceable.
Key Highlights
A safer technical layer for database work inside Odoo, focused on access control, validation, traceability, and practical result handling.
Permission-based SQL access
Assign users to progressive access levels: query-only, query and update, or query, update, and delete.
Execution guardrails
Block dangerous keywords, unsafe PostgreSQL functions, transaction control, and writes to protected Odoo tables.
Auditable execution history
Store the executed SQL, user, duration, row count, status, rendered preview, and exportable result data.
1. User-level access control
Grant data-operation permissions directly from the Odoo user form. The module exposes clear access levels so administrators can decide who may only read data, who may perform updates, and who is trusted to run delete operations.
2. Dedicated menus for declarations and executions
PG Data Ops adds a focused technical menu for SQL declarations and execution history. Users can separate reusable statements from the immutable audit log, keeping day-to-day work organized and easy to review.
3. SELECT declarations with readable result previews
Run read-only SQL declarations and inspect the output in a structured result grid. Sticky column headers, row numbers, execution metadata, and export access help users understand exactly what was returned.
4. Export wizard for CSV, Excel, and JSON
Export the stored execution result without running SQL again. The wizard supports practical options such as headers, CSV separator, quote character, line endings, UTF-8 BOM, Excel sheet name, and JSON layout.
5. UPDATE declarations that return the changed rows
When an UPDATE declaration does not include a RETURNING clause, the module adds RETURNING * automatically. Users can immediately inspect the updated records while keeping the full execution audited.
Core Features
Frequently Asked Questions
Can users execute dangerous database operations?
The module intentionally blocks high-risk operations such as DROP, ALTER, TRUNCATE, GRANT, transaction control, unsafe PostgreSQL functions, and DML on protected Odoo tables.
Can an UPDATE be tested without keeping the changes?
Yes. Enable safe execution to run the declaration inside a savepoint. The module captures the result and immediately rolls back the SQL changes.
Does exporting data execute the SQL again?
No. The export wizard uses the stored result from the selected execution, so it does not re-run SQL or change the database.
Latest Release
19.0.1.0.3
Adds the export wizard, safe execution support, automatic RETURNING for UPDATE declarations, translated access labels, and improved SQL result rendering.
Odoo Services
Available for implementation, customization, technical support, migrations, integrations, and advisory work.
Email: danychavezdev@gmail.com | WhatsApp: +51 939 835 705
SOFTWARE LICENSE AGREEMENT ========================== Effective 2026 Copyright (c) 2026 Dany Anderson Chavez Pauca This Software License Agreement (the "Agreement") is made between Dany Anderson Chavez Pauca (the "Licensor") and the purchaser (the "Licensee"). By accepting or using the Software—comprising multiple Odoo modules across various repositories—the Licensee agrees to be bound by the terms set forth below. 1. Grant of License The Licensor grants the Licensee a non-exclusive, non-transferable, revocable license to use the Software solely for Licensee’s internal purposes and for projects developed and maintained directly by Licensee. This Agreement expressly prohibits any form of redistribution, sublicensing, or commercialization of the Software. 2. Permitted Use The Software is sold directly to the Licensee and may only be used within Licensee’s own projects. The Licensee is not permitted to distribute, resell, lease, or otherwise commercialize the Software or any derivatives thereof. Unauthorized distribution or commercialization may result in legal action. 3. Restrictions on Distribution and Commercialization The Licensee shall not distribute, share, or make the Software available to any third party in any form—either as a standalone product or as part of another project. Any breach of this provision will be considered a material violation of this Agreement, subjecting the Licensee to immediate termination of the license and potential legal liability. 4. Ownership and Intellectual Property Rights All rights, title, and interest in and to the Software, including any modifications or improvements, remain the exclusive property of the Licensor. Licensee acknowledges that no title or ownership rights are transferred under this Agreement. 5. Modifications and Maintenance Any modifications, enhancements, or maintenance work on the Software shall only be performed with the prior written consent of the Licensor. Licensee shall not alter any portion of the Software that would permit its resale or redistribution. 6. Warranty Disclaimer and Limitation of Liability The Software is provided "as is," without warranty of any kind, either express or implied, including but not limited to any implied warranties of merchantability, fitness for a particular purpose, or non-infringement. In no event shall the Licensor be liable for any damages (including direct, indirect, incidental, consequential, or punitive damages) arising out of the use or inability to use the Software, even if advised of the possibility of such damages. 7. Indemnification The Licensee agrees to indemnify, defend, and hold harmless the Licensor from any claims, damages, liabilities, costs, or expenses (including reasonable attorneys' fees) arising from Licensee's use of the Software or any breach of this Agreement. 8. Termination This Agreement is effective until terminated. The Licensee's rights under this Agreement will terminate automatically if any term or condition is breached. Upon termination, the Licensee shall immediately cease all use of the Software and destroy all copies in its possession or control. 9. Governing Law This Agreement shall be governed by and construed in accordance with the laws of the applicable jurisdiction, without regard to its conflict of law provisions. 10. Entire Agreement This Agreement constitutes the entire understanding between the parties regarding the Software and supersedes any prior agreements, whether written or oral. By using the Software, the Licensee acknowledges that it has read, understood, and agrees to be bound by the terms and conditions of this Agreement.
Please log in to comment on this module