About
Universal DB AI is a practical hub for Odoo automation, API integration, VPS security, backups, and AI-assisted database work. It is built around real workflows, not theory.
The focus is the part most quick tutorials skip: doing the work without breaking production. That means understanding what is exposed before connecting a domain, taking backups that can actually be restored, and automating data flows that handle messy real-world input instead of perfect sample data.
I'm Florian, a consultant working on Odoo automation, API integrations, database/AI workflows, and the hosting and security side of self-hosted Odoo.
Most of my work sits at the point where small and medium businesses outgrow manual processes: data being copied by hand between systems, an Odoo server that was set up quickly and never audited, backups that nobody has ever tested, or reporting that takes too long to pull together. I help make those parts reliable, safer, and less dependent on someone remembering to do them manually.
The guides on this site are a fair sample of how I approach that work: audit first, understand what can break, and prefer reversible, well-documented changes over fast fixes on production.
Odoo automation & integration
Connect Odoo to other tools and remove repetitive manual data entry between systems.
API & data pipelines
Move data between sources and Odoo reliably, with validation and handling for dirty or duplicate records.
VPS security & safe hosting
Audit and harden self-hosted Odoo so the database, admin routes, and ports are not exposed to the internet.
Backups & restore testing
Set up backups that actually include the filestore and addons — and that have been proven by a real restore.
Migration planning
Plan Odoo moves and upgrades with rollback paths, so production is not put at risk during the change.
AI & database reporting
Make business data easier to query and report on, including AI-assisted access to Odoo and SQL systems.
Rather than list buzzwords, here is some of the actual work, written up in full. These are the same checks and decisions I apply on real deployments — you can read them, use them yourself, or have me handle the work for you.
How to secure Odoo on a VPS →
AvailableA practical checklist for new Odoo installs and existing VPS audits: SSH, firewall rules, Docker exposure, Odoo ports, PostgreSQL access, odoo.conf hardening, database manager protection, backups, and final security checks.
How to host Odoo on a subdomain with HTTPS →
AvailableConnect Odoo to a clean subdomain using DNS, Nginx, HTTPS, proxy headers, websocket routing, and database manager protection.
Odoo backups: database, filestore, and custom modules →
AvailableUnderstand what a real Odoo backup must include: PostgreSQL database, filestore, custom addons, configuration files, off-server storage, and restore testing.
How to create a safe Odoo sandbox →
Coming soonPrepare a separate Odoo environment for testing backups, restores, automations, upgrades, migrations, custom modules, and AI/database integrations without touching production.
How to plan an Odoo migration without losing workflows →
Coming soonA practical migration planning checklist for data, modules, users, workflows, integrations, validation, and rollback planning.
More guides and a practical automation case study are in progress.
It is easy to find a quick answer for how to do something. It is much harder to find one that covers the operational risks: backups, permissions, production safety, rollback plans, testing environments, data validation, and long-term maintainability.
Universal DB AI documents the full picture instead — what to check before doing the work, what can break, and how to approach it safely. That is also how I prefer to work with clients.
This project is connected to Speak To Your Database, a private-beta AI assistant designed to help teams ask business questions directly from Odoo and SQL-based systems, without writing queries by hand.
Learn about STYD →Working on Odoo automation, an API integration, database reporting, a migration, or securing a self-hosted server? There are two easy ways to start.
Quick, low-commitment first step
Send me your setup or sanitized command output — for example the result of ss -tulpn from your Odoo server — and I can help you understand what is exposed and what is worth fixing first.
Scoped project or call
If you already know what you need, book a call or view services to discuss a fixed-scope automation, security audit, backup setup, or integration.