I will write postgresql queries and odoo reports for sales, pos and inventory
About this Gig
Need numbers your system's built-in reports can't give you? I write clear, fast SQL that answers the actual business question.
I specialise in PostgreSQL and Odoo. I write production reports over Odoo's POS, sales and inventory tables: multi-location stock distribution, sales converted by each location's currency, customer name cleaning with regex, and pivot-style summaries by branch, product and period.
What I can do:
- Write new queries, or fix slow and wrong ones
- Build CTE-based reports that stay readable
- Clean and standardise messy fields (names, phones, SKUs)
- Turn queries into views, CSV or Excel exports, or Google Sheets feeds
- Explain the logic so your team can maintain it
Works with PostgreSQL, Odoo with database access (self-hosted or Odoo.sh), and other SQL databases on request.
Message me first with your database type, the tables involved and an example of the output you want. Read-only access or an anonymised dump is all I need.
Platform:
MySQL
•
PostgreSQL
Expertise:
Data center
•
SQL
•
Performance
•
Query optimization
My Portfolio
FAQ
I use Odoo Online. Can you still help?
Odoo Online doesn't give direct database access. I can work from exported data instead; message me first.
Do you need write access to my database?
No. A read-only user, or an anonymised backup, is enough for reporting work.
Can you make an existing query faster?
Yes. Send the query and its runtime, and I'll return a rewritten version with the changes explained.
MySQL or SQL Server?
Message me first. PostgreSQL and Odoo are my core, and I'll only take other databases when the job is a clear fit

