Finding Your Odoo Database ID
Your Odoo database ID is a unique identifier required for API connections. The method to find it differs between Odoo Online and self-hosted installations.
For Odoo Online (SaaS)
Method 1: From the URL
- Log in to your Odoo instance
- Navigate to any page (e.g., Settings)
- Look at the URL in your browser
The URL will look like:
https://mycompany.odoo.com/web#id=1&action=55&...
Your database name is the subdomain (mycompany in this example).
Method 2: From Developer Tools
-
Enable Developer Mode:
- Go to Settings
- Scroll to the bottom
- Click Activate the developer mode
-
Open Developer Menu:
- Click the bug icon in the top right
- Select About
-
Find Database ID:
- The dialog will show your database name and other technical information
For Self-Hosted Odoo
Method 1: From Odoo Configuration
- Log in to your Odoo instance as administrator
- Go to Settings → Technical → Database Structure → Databases
- View the list of databases
Your database name is shown in the list. For multi-database installations, note the exact name you want to connect to.
Method 2: From Server Configuration File
If you have access to the server:
- Open the Odoo configuration file (usually
/etc/odoo/odoo.conf) - Look for the
db_nameparameter - Note the database name
Example:
[options]
db_name = production_db
db_host = localhost
db_port = 5432
Method 3: From Database Manager
- Navigate to
http://your-odoo-url/web/database/manager - Log in with the master password
- View the list of available databases
Security Note: The database manager should be disabled in production for security reasons.
Common Issues
Issue: Multiple Databases Listed
If you see multiple databases, choose the one you actively use for production. Contact your system administrator if you're unsure.
Issue: Can't Access Technical Menu
Enable Developer Mode first (Settings → Activate developer mode).
Issue: Permission Denied
You need administrator access to view database information. Contact your Odoo administrator.
Next Steps
Once you have your database ID, proceed to:
- Connecting to Odoo Online for SaaS installations
- Connecting to Self-Hosted Odoo for on-premise installations