MCP: use STYD from AI apps
Version françaiseUse STYD from ChatGPT (MCP)
Ask business questions about your company's data from ChatGPT, with the Speak To Your Database (STYD) app.
What you need
- A STYD workspace with prompts left and, to ask about your own company, at least one Odoo, PostgreSQL or MySQL connection — see “If you have not connected your data yet” below.
- A role that can ask questions: owner, admin or member, in a workspace where AI apps are allowed (they are by default).
If you have not connected your data yet
You can add STYD to ChatGPT first. If you have no STYD workspace yet, STYD creates one for you the first time ChatGPT calls it, with the free prompts and the sample companies that come with a new account. If your STYD account has no data of its own yet, ChatGPT tells you plainly that nothing is connected and where to connect it.
In the meantime you can try STYD on fictional sample companies: a DVD rental store and an airline (PostgreSQL), and an office-supply company (Odoo). STYD tells ChatGPT to use a sample only if you agree, and to say that the data is fictional, not yours. A question on a sample uses a prompt like any other question.
- Odoo: open Connect Odoo. In Odoo, click your avatar, open your profile, then Account Security → New API Key (turn on developer mode if you do not see it; if Odoo asks for a scope, choose RPC: Odoo 20 refuses any other scope). Create the key as the Odoo user whose data STYD should read. A dedicated user is best: no member ever sees more than that user can read, and a key from an Odoo administrator lets each member get their own Odoo rights. Odoo 15 or later; Odoo Online, Odoo.sh and on-premise. Help: Odoo connection.
- PostgreSQL or MySQL: open Connect a database and use a read-only database user. STYD uses an encrypted connection when your server offers one. Help: Read-only database users.
- Firewall and addresses: if your Odoo server blocks STYD (a firewall such as Cloudflare), write to us at contact@speaktoyourdatabase.com and we’ll help you connect. If your database server only accepts known addresses, allow STYD’s addresses
109.123.235.222(IPv4) and2407:3640:2324:5796::1(IPv6). STYD cannot reach a server that only has a localhost or private-network address: use its public address. - What happens next: STYD reads the structure of a database. Your first AI Guide analysis is included while your workspace still has a setup left (see Pricing) and starts by itself; otherwise an owner or admin sees its price and confirms it. You can already ask questions before the analysis is done. Odoo needs no analysis, and STYD takes you to your first Business Checkup, which starts by itself. Sign in to STYD with the same email you used to connect ChatGPT.
How to connect
- Open Plugins in ChatGPT. In ChatGPT, open Plugins (or go straight to the STYD plugin page).
- Find STYD. Search for “Speak To Your Database”.
- Install. Open the plugin and click Install plugin.
- Sign in to STYD and approve. A STYD page opens: continue with Google, or enter your email address and open the sign-in link STYD sends you. STYD shows what ChatGPT will be able to do — read data you already have access to, read-only — and the account you are signed in with. Check the account, then choose Allow.
- Ask. Back in ChatGPT, ask your question in a chat where the STYD plugin is turned on.
Connecting Odoo? Follow the step-by-step guide: How to connect Odoo to ChatGPT.
Example questions
Odoo
- “What was our revenue last month?”
- “Which customers have overdue invoices, and how much do they owe?”
PostgreSQL or MySQL
- “Who were our top 5 customers by total spend last year?”
Ask about your own data in your own words; put the period, customer, product or status in the question. Answers come in the language of the question.
Cost and safety
- Each answer uses one prompt of the workspace the question is about. Listing your workspaces and data sources is free.
- Read-only. STYD only reads your data, with your own access; passwords, tokens, keys, and card or bank numbers are always hidden.
- Uninstall the plugin any time in ChatGPT, or disconnect it in STYD under Settings → AI apps. Details on tools, limits and control: the Claude page (they are the same).
Need help? Contact support