mcpField
S
Speak To Your Database (STYD)

Speak To Your Database (STYD)

リモート
speaktoyourdatabase.comデータベース11 日前に更新
リポジトリ公式サイト

Speak To Your Database (STYD) について

Speak To Your Database(STYD)は、Odoo、PostgreSQL、MySQL の業務データを自然言語で質問できる、ホスト型の読み取り専用 MCP サーバーです。使用した期間や条件とともに集計値を返し、会社ごとのワークスペースを分離します。

主な機能

  1. 01自然言語で業務データに質問
  2. 02Odoo、PostgreSQL、MySQL の接続
  3. 03期間や集計条件を添えて数値を返却
  4. 04会社ごとにワークスペースを分離
  5. 05接続データへの読み取り専用アクセス

活用シーン

  1. 01異なる期間の売上を比較
  2. 02未払い請求書と債務額を確認
  3. 03顧客やステータス別に注文を集計
  4. 04売上額や数量別に商品を確認

MCP 対応

ワークスペースと接続の一覧、利用可能なデータの説明、質問への回答、時間のかかる処理結果の取得ツールを提供します。Odoo、PostgreSQL、MySQL に接続するホスト型のリモート MCP サーバーです。

設定

リモートサーバーはインストール不要です。クライアントを選んで設定をコピーするか、ワンクリックで導入できます。

エンドポイントhttps://speaktoyourdatabase.com/mcp
インストールコマンドをコピー
Claude CodeTerminal
Cursor.cursor/mcp.json
VS Code.vscode/mcp.json
Claude Desktopclaude_desktop_config.json
Windsurf~/.codeium/windsurf/mcp_config.json

コマンドはターミナルで実行し、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.

Speak To Your Database MCP connector

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).

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

  1. Add the connector to your AI app (see below).
  2. Sign in to STYD when your app asks. The free plan includes sample data, so you can ask questions straight away.
  3. 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

ToolWhat it does
list_workspacesLists the STYD workspaces (companies) you belong to
list_connectionsLists the data sources in a workspace: Odoo, PostgreSQL, MySQL, sample data
describe_available_dataShows what a connection can answer, with example questions
ask_questionAsks one business question and returns the answer computed from your data
get_answerFetches 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.

コメント

MCP は初めてですか?

プロトコルの概要から最初のサーバーの導入まで、よくある疑問にまとめて答えます。

AI アプリケーションが外部のツールやデータソースに統一的な方法で接続するためのオープンなプロトコルです。クライアントはモデルとの対話を担い、MCP サーバーはツール・リソース・プロンプトテンプレートを提供します。標準メッセージでやり取りするため、1 つのサーバーを複数のクライアントで再利用できます。