Odoo MCP connector (Speak To Your Database) について
Speak To Your Database は、Odoo、PostgreSQL、MySQL の業務データを自然言語で質問できる、ホスト型の読み取り専用 MCP サーバーです。対応する AI アプリの利用者向けに、期間や集計条件を添えた計算結果を返します。
主な機能
- 01Odoo、PostgreSQL、MySQL の読み取り専用クエリ
- 02自然言語での業務質問
- 03売上、請求書、顧客、製品、在庫の照会
- 04期間とフィルターを明記した結果
- 05企業ごとに分離されたワークスペース
活用シーン
- 01期間ごとの売上比較
- 02延滞請求書と顧客別債務の確認
- 03顧客とステータス別の受注集計
- 04売上上位製品の確認
MCP 対応
ワークスペースや接続の確認、データの説明、質問、時間のかかる結果の取得を MCP ツールとして提供します。対応クライアントはホスト型エンドポイントに接続できます。
設定
リモートサーバーはインストール不要です。クライアントを選んで設定をコピーするか、ワンクリックで導入できます。
https://speaktoyourdatabase.com/api/v1/mcpclaude mcp add --transport http com-speaktoyourdatabase-odoo https://speaktoyourdatabase.com/api/v1/mcp{"mcpServers":{"com-speaktoyourdatabase-odoo":{"type":"http","url":"https://speaktoyourdatabase.com/api/v1/mcp"}}}Cursor で開く{"servers":{"com-speaktoyourdatabase-odoo":{"type":"http","url":"https://speaktoyourdatabase.com/api/v1/mcp"}}}VS Code で開く{"mcpServers":{"com-speaktoyourdatabase-odoo":{"type":"http","url":"https://speaktoyourdatabase.com/api/v1/mcp"}}}{"mcpServers":{"com-speaktoyourdatabase-odoo":{"serverUrl":"https://speaktoyourdatabase.com/api/v1/mcp"}}}コマンドはターミナルで実行し、JSON は各クライアントの MCP 設定に貼り付けて再起動します。認可が必要なサーバーは初回接続時にログインを求めます。
ツール
README(原文)English
プロジェクトの README よりこの README の日本語訳はまだありません。以下は英語の原文です。日本語の紹介はページ上部をご覧ください。
Speak To Your Database (STYD)
Odoo, PostgreSQL & MySQL MCP server for Claude and ChatGPT. Ask your business data in plain words, from the AI app you already use. Real numbers, computed read-only from your data.
STYD is a hosted MCP server. Connect it once to Claude, ChatGPT, Le Chat, VS Code or any app that supports remote MCP servers, then ask things like:
- "How much revenue did we make last month, compared with the month before?"
- "Which customer invoices are overdue, and how much does each customer owe?"
- "Show all sales orders grouped by customer and status, with the number of orders, the total amount and the date range."
- "Top 10 products by sales this year"
- "Why did sales drop this month?"
Follow-ups work too: after the sales orders question, ask "and only the confirmed ones?" and STYD keeps the same grouping.
STYD works out the answer from your data and sends back the numbers, with the period and the definition it used (for example, revenue = posted customer invoices, excluding tax).
- Website: https://speaktoyourdatabase.com
- MCP endpoint:
https://speaktoyourdatabase.com/mcp - Demo video: https://www.youtube.com/watch?v=PZffAbynuc0
- Docs: https://speaktoyourdatabase.com/docs/mcp
- Odoo MCP guide: https://speaktoyourdatabase.com/docs/odoo-mcp
This repository holds the public setup guide and the registry file. STYD itself is a hosted service; its source code is not public.
Odoo MCP connector
STYD is an Odoo MCP server for Claude, ChatGPT and other MCP apps. Ask about sales, invoices, unpaid amounts, customers, products and stock in plain words, and get the figures with what was counted, over which period and with which filters.
- Odoo 15 to 20, on Odoo Online, Odoo.sh or your own server.
- Two ways to connect: an Odoo API key (Online, Odoo.sh, on-premise) or the free STYD Bridge module (Odoo.sh, on-premise).
- Read-only: STYD cannot create, change or delete anything in Odoo.
- Nothing to install on your computer: STYD is hosted, and your AI app signs in to your STYD account.
- Several companies: each company stays in its own workspace, and every answer names the one it comes from.
Example questions: "Which customers owe us the most, and how much is overdue?", "Top 5 products by quantity sold this quarter", "Compare this month's sales with the same month last year."
Full guide: https://speaktoyourdatabase.com/docs/odoo-mcp
Try it in 2 minutes
- Add the connector to your AI app (see below).
- Sign in to STYD when your app asks. The free plan includes sample data, so you can ask questions straight away.
- When you are ready, connect your own Odoo, PostgreSQL or MySQL database at https://speaktoyourdatabase.com/connections.
Set up in your AI app
Claude (web, desktop, mobile)
Open Settings → Connectors, search the directory for Speak To Your Database, and click Connect. Directory page: https://claude.ai/directory/speak-to-your-database
Claude Code
claude mcp add --transport http styd https://speaktoyourdatabase.com/mcp
Then run /mcp in Claude Code and sign in.
VS Code (GitHub Copilot)
Run MCP: Add Server from the Command Palette, choose HTTP, and paste https://speaktoyourdatabase.com/mcp. Or add this to .vscode/mcp.json:
{
"servers": {
"styd": {
"type": "http",
"url": "https://speaktoyourdatabase.com/mcp"
}
}
}
Start the server, sign in when VS Code asks, then use Copilot Chat in Agent mode.
Le Chat (Mistral)
Add a custom MCP connector with the URL https://speaktoyourdatabase.com/mcp, then sign in to STYD when asked.
ChatGPT
Open Plugins in ChatGPT, search for Speak To Your Database, and click Install plugin. Sign in to STYD when asked. Plugin page: https://chatgpt.com/plugins/plugin_asdk_app_6ac9e3034d488191bd0b9a624cb1f0ae
Cursor and other apps
Any app that supports remote MCP servers with OAuth sign-in can use https://speaktoyourdatabase.com/mcp. For Cursor and apps without sign-in support, use a workspace API key: see https://speaktoyourdatabase.com/docs/mcp/other-apps.
Tools
| Tool | What it does |
|---|---|
list_workspaces | Lists the STYD workspaces (companies) you belong to |
list_connections | Lists the data sources in a workspace: Odoo, PostgreSQL, MySQL, sample data |
describe_available_data | Shows what a connection can answer, with example questions |
ask_question | Asks one business question and returns the answer computed from your data |
get_answer | Fetches the result of a longer-running question |
Every answer names the workspace it comes from, so data from different companies is never mixed.
Security
STYD reads your data; it never changes it.
- Read-only: STYD cannot create, change or delete anything in Odoo or your databases.
- Secrets protected: database passwords and API keys are stored encrypted and never shown back.
- Standard sign-in: AI apps connect through OAuth. You approve each app on a STYD consent page, and you can revoke it at any time.
- Uploaded files checked with a malware scan before use.
- Backups with an encrypted off-site copy.
- Abuse protection and rate limits.
- Not used for training: your data and questions are not used to train AI models.
Details: https://speaktoyourdatabase.com/security and https://speaktoyourdatabase.com/privacy
Need STYD on your own server, with nothing leaving your network? See https://speaktoyourdatabase.com/private.
Registry
STYD is published in the official MCP Registry as com.speaktoyourdatabase/styd (the server.json in this repository) and as com.speaktoyourdatabase/odoo-mcp (the Odoo MCP connector entry).
Also listed in the ChatGPT plugin directory, the Claude connectors directory and on Glama.
Support
Questions, a source you would like supported, or something that did not work: https://speaktoyourdatabase.com/support, or open an issue in this repository.
Built by Florian Assous.
コメント
AI アプリケーションが外部のツールやデータソースに統一的な方法で接続するためのオープンなプロトコルです。クライアントはモデルとの対話を担い、MCP サーバーはツール・リソース・プロンプトテンプレートを提供します。標準メッセージでやり取りするため、1 つのサーバーを複数のクライアントで再利用できます。