Connect an AI app to Exploratory through MCP. There are two sides, and the first thing to decide is which one you need.
Server
Desktop
What it works on
Content you published to exploratory.io (notes, dashboards, charts, analytics and data)
The projects in Exploratory Desktop on your computer, including changes you have not published
What it does
Reads. It cannot create, edit, publish or delete
Creates and edits: data frames, wrangling steps, charts, analytics, notes and dashboards
Where you set it up
In your AI app, with the server URL and a sign-in in your browser
In Exploratory Desktop, System Settings, with the plugin installation card
Server - Read content published on exploratory.io.
Desktop - Create and edit projects in Exploratory Desktop on your computer.
Was this page helpful?
{"docsConfig":{"theme":"aspen","$schema":"https://mintlify.com/docs.json","name":"Exploratory","description":"Documentation for Exploratory Desktop, Exploratory Server, MCP and CLI.","colors":{"primary":"#00ab6d","light":"#00ab6d","dark":"#00ab6d"},"logo":{"light":"https://mintcdn.com/exploratory-inc/t8wulpy3B474-b7T/en/markdown/images/logo_top.png?fit=max\u0026auto=format\u0026n=t8wulpy3B474-b7T\u0026q=85\u0026s=370661a35e27b492bc5d04396b5573fd","dark":"https://mintcdn.com/exploratory-inc/t8wulpy3B474-b7T/en/markdown/images/logo_top.png?fit=max\u0026auto=format\u0026n=t8wulpy3B474-b7T\u0026q=85\u0026s=370661a35e27b492bc5d04396b5573fd"},"favicon":"https://mintcdn.com/exploratory-inc/-5HxVvjEaUz0PUYx/images/favicon.png?fit=max\u0026auto=format\u0026n=-5HxVvjEaUz0PUYx\u0026q=85\u0026s=cfad2e8089c2c5293daafa43ede7e311","appearance":{"default":"light","strict":true},"seo":{"metatags":{"canonical":"https://docs.exploratory.io"}},"styling":{"latex":false},"navigation":{"languages":[{"language":"en","default":true,"href":"en"},{"language":"ja","href":"ja"}]}},"deployment":{"deploymentMetadataValue":{"subdomain":"exploratory-inc","hasAudioNarration":false,"actualSubdomain":"exploratory-inc","customDomains":["docs.exploratory.io"],"gitSource":{"type":"github","owner":"exploratory-io","repo":"book","deployBranch":"master","contentDirectory":"","isPrivate":false,"mountPath":"","label":"","_id":"6afd1e9171d298464993c5e4"},"feedback":{"thumbs":true},"entitlements":{"AI_CHAT":{"status":"ENABLED"},"WEB_MCP":{"status":"ENABLED"},"NARRATION":{"status":"ENABLED"}},"buildId":"6afd65cb9b4313a2fa6fa015","clientVersion":"0.0.4177","searchFilterCounts":[{"language":"en","tag":"Exploratory","count":327},{"language":"ja","tag":"Exploratory","count":79},{"language":"en","tag":"Visualization","count":56},{"language":"en","tag":"Data Import","count":53},{"language":"en","tag":"Data Wrangling","count":48},{"language":"en","tag":"Analytics","count":37},{"language":"en","tag":"Exploratory CLI","count":33},{"language":"ja","tag":"Exploratory CLI","count":33},{"language":"en","tag":"Features","count":31},{"language":"en","tag":"Server","count":30},{"language":"ja","tag":"Server","count":30},{"language":"en","tag":"Machine Learning","count":26},{"language":"en","tag":"Product Features","count":25},{"language":"ja","tag":"Desktop","count":24},{"language":"ja","tag":"Exploratory MCP","count":21},{"language":"ja","tag":"リファレンス","count":17},{"language":"ja","tag":"はじめる","count":16},{"language":"ja","tag":"使い方","count":15},{"language":"ja","tag":"製品の機能","count":12},{"language":"ja","tag":"AI ツールから追加する","count":8}],"searchSettings":{"showContentSnippets":true}},"assistantConfig":{"enableAskAiButton":false,"enableStarterQuestions":false,"enableContextualStarterQuestions":false,"enableAskAiSearchBar":true},"basePath":"","hasChatPermissions":true,"hasWebMcpPermissions":true,"toggles":[{"name":"kill-isr","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-rbac-roles","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-mintlify-slack","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-integrations-settings","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"rbac-expansion","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-pr-grouping","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-prefix","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"analytics-v7","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"user-flows-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"no-publish-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-onboarding","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving-live","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"stripTemperatureMiddleware","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"support-platform-pylon-zendesk","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"instant-rollback","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications-server","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-fable","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fixed-ai-action-pricing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automation-resolve-merge-conflict","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"scoped-publishing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"mintql","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"page-level-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-version-history-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"billing-page-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"full-page-search","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workspace-projects","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"assistant-v5","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fork-pr-previews","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"revalidation-jwt","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-sso-scim","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"hobby-abuse-scan","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"dashboard-inbox","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-signup","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-dual-write","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-enabled","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"approve-review-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-metadata","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"sso-setup-deadline-banner","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-serve","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"live-agents","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"starter-pricing","enabled":true,"variant":{"name":"control","enabled":true,"payload":{"type":"string","value":"control"},"feature_enabled":true},"impressionData":false},{"name":"llms-txt-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"wildcard-email-auth","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false}],"googleFontsInlined":false},"customCss":[{"filePath":"en/styles/website.css","content":""},{"filePath":"style.css","content":"@media (min-width: 1024px){#navbar div:has(>#localization-select-trigger){position:absolute;right:1.5rem;top:50%;transform:translateY(-50%)}}#navbar a:has(>.nav-logo)::before,#navbar a:has(.nav-logo)::before{content:\"\";display:inline-block;flex:none;width:24px;height:24px;margin-right:8px;vertical-align:middle;background:url(\"/images/favicon.png\") center / contain no-repeat}#navbar a:has(.nav-logo){display:inline-flex;align-items:center}#navbar .nav-logo{height:20px}#sidebar-content .sidebar-title{display:none}#sidebar-content ul ul{margin-left:16px;padding-left:4px;border-left:1px solid #e5e9e7}#sidebar-content ul ul a,#sidebar-content ul ul button{padding-left:12px!important}.mdx-content a.link,.mdx-content a.link code{color:#00ab6d}.mdx-content a.link:hover{text-decoration:underline}.mdx-content table{border-collapse:separate;border-spacing:0;border:1px solid #e5e9e7;border-radius:8px;overflow:hidden}.mdx-content table thead,.mdx-content table tr{border:0}.mdx-content table th{padding:10px 12px!important;background:#f5f7f6;border-bottom:1px solid #e5e9e7}.mdx-content table td{padding:10px 12px!important;border-bottom:1px solid #eef1f0}.mdx-content table th+th,.mdx-content table td+td{border-left:1px solid #eef1f0}.mdx-content table tbody tr:last-child td{border-bottom:0}"}],"page":{"pagePath":"en/mcp","slug":"/en/mcp","pageMetadata":{"title":"Exploratory MCP","description":null,"href":"/en/mcp"},"pageType":"default","mdx":{"mdxSource":{"compiledSource":"\"use strict\";const{Fragment:_Fragment,jsx:_jsx,jsxs:_jsxs}=arguments[0];const{useMDXComponents:_provideComponents}=arguments[0];function _createMdxContent(props){const _components={a:`a`,li:`li`,p:`p`,tbody:`tbody`,td:`td`,th:`th`,thead:`thead`,tr:`tr`,ul:`ul`,..._provideComponents(),...props.components},{Table}=_components;if(!Table)_missingMdxReference(`Table`,true);return _jsxs(_Fragment,{children:[_jsx(_components.p,{children:`Connect an AI app to Exploratory through MCP. There are two sides, and the first thing to decide is which one you need.`}),`\n`,_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{}),_jsx(_components.th,{children:`Server`}),_jsx(_components.th,{children:`Desktop`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`What it works on`}),_jsx(_components.td,{children:`Content you published to exploratory.io (notes, dashboards, charts, analytics and data)`}),_jsx(_components.td,{children:`The projects in Exploratory Desktop on your computer, including changes you have not published`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`What it does`}),_jsx(_components.td,{children:`Reads. It cannot create, edit, publish or delete`}),_jsx(_components.td,{children:`Creates and edits: data frames, wrangling steps, charts, analytics, notes and dashboards`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Where you set it up`}),_jsx(_components.td,{children:`In your AI app, with the server URL and a sign-in in your browser`}),_jsx(_components.td,{children:`In Exploratory Desktop, System Settings, with the plugin installation card`})]})]})]}),`\n`,_jsxs(_components.ul,{children:[`\n`,_jsxs(_components.li,{children:[_jsx(_components.a,{href:`/en/mcp/server`,children:`Server`}),` - Read content published on exploratory.io.`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.a,{href:`/en/mcp/desktop`,children:`Desktop`}),` - Create and edit projects in Exploratory Desktop on your computer.`]}),`\n`]})]})}function MDXContent(props={}){const{wrapper:MDXLayout}={..._provideComponents(),...props.components};return MDXLayout?_jsx(MDXLayout,{...props,children:_jsx(_createMdxContent,{...props})}):_createMdxContent(props)}return{default:MDXContent};function _missingMdxReference(id,component){throw new Error(`Expected `+(component?`component`:`object`)+\" `\"+id+\"` to be defined: you likely forgot to import, pass, or provide it.\")}","frontmatter":{},"scope":{"config":{},"pageMetadata":{"title":"Exploratory MCP","description":null,"href":"/en/mcp"}}},"mdxSourceWithNoJs":null},"mdxExtracts":{"tableOfContents":[],"codeExamples":{}},"jsLinks":[],"subdomain":"exploratory-inc","siteName":"Exploratory","title":"Exploratory MCP - Exploratory","navMaps":{"firstHrefInVersion":{},"firstHrefInLanguage":{"en":{"href":"/en/mcp","matchLevel":0},"ja":{"href":"/ja/mcp","matchLevel":1}}},"lastModified":"2026-11-18T07:00:28.879Z","originalFileLocation":"en/mcp.md","locale":"en"},"headHtml":"\u003cscript data-mint-head>(function(){var d=document.documentElement,p=\"light\";if(!p){try{p=localStorage.getItem(\"isDarkMode\")}catch(e){}if(p==='true')p='dark';else if(p==='false')p='light';if(p!=='light'\u0026\u0026p!=='dark'\u0026\u0026p!=='system')p=\"light\"}var r=p==='system'?(matchMedia(\"(prefers-color-scheme: dark)\").matches?'dark':'light'):p;d.classList.remove(r==='dark'?'light':'dark');d.classList.add(r);d.setAttribute(\"data-theme-preference\",p)})();\u003c/script>\u003cmeta data-mint-head name=\"application-name\" content=\"Exploratory\">\u003cmeta data-mint-head name=\"generator\" content=\"Mintlify\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/exploratory-inc/9mPjptrIZN2icevd/_generated/favicon/android-chrome-192x192.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"apple-touch-icon\" type=\"image/png\" sizes=\"180x180\" href=\"/mintlify-assets/_mintlify/favicons/exploratory-inc/9mPjptrIZN2icevd/_generated/favicon/apple-touch-icon.png\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/exploratory-inc/9mPjptrIZN2icevd/_generated/favicon/favicon-16x16.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/exploratory-inc/9mPjptrIZN2icevd/_generated/favicon/favicon-32x32.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/exploratory-inc/9mPjptrIZN2icevd/_generated/favicon/favicon.ico\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/exploratory-inc/9mPjptrIZN2icevd/_generated/favicon-dark/android-chrome-192x192.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/exploratory-inc/9mPjptrIZN2icevd/_generated/favicon-dark/favicon-16x16.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/exploratory-inc/9mPjptrIZN2icevd/_generated/favicon-dark/favicon-32x32.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/exploratory-inc/9mPjptrIZN2icevd/_generated/favicon-dark/favicon.ico\" media=\"(prefers-color-scheme: dark)\">\u003cmeta data-mint-head property=\"og:title\" content=\"Exploratory MCP - Exploratory\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"Exploratory\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://docs.exploratory.io/en/mcp\">\u003cmeta data-mint-head property=\"og:type\" content=\"website\">\u003cmeta data-mint-head property=\"og:image\" content=\"https://exploratory-inc.mintlify.site/_mintlify/api/og/v2?division=Documentation\u0026amp;title=Exploratory+MCP\u0026amp;theme=d875c51dedd76fd973af8cde\u0026amp;signature=6cce6ab9714f964eb649a9210b8ec510a2a6ab21a01ccf4982e750ebb091b0d8\">\u003cmeta data-mint-head property=\"og:image:width\" content=\"1200\">\u003cmeta data-mint-head property=\"og:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"twitter:card\" content=\"summary_large_image\">\u003cmeta data-mint-head name=\"twitter:title\" content=\"Exploratory MCP - Exploratory\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://exploratory-inc.mintlify.site/_mintlify/api/og/v2?division=Documentation\u0026amp;title=Exploratory+MCP\u0026amp;theme=d875c51dedd76fd973af8cde\u0026amp;signature=6cce6ab9714f964eb649a9210b8ec510a2a6ab21a01ccf4982e750ebb091b0d8\">\u003cmeta data-mint-head name=\"twitter:image:width\" content=\"1200\">\u003cmeta data-mint-head name=\"twitter:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"msapplication-config\" content=\"/mintlify-assets/_mintlify/favicons/exploratory-inc/9mPjptrIZN2icevd/_generated/favicon/browserconfig.xml\">\u003cmeta data-mint-head name=\"apple-mobile-web-app-title\" content=\"Exploratory\">\u003cmeta data-mint-head name=\"msapplication-TileColor\" content=\"#00ab6d\">\u003clink data-mint-head rel=\"canonical\" href=\"https://docs.exploratory.io/en/mcp\">\u003clink data-mint-head rel=\"alternate\" type=\"application/xml\" href=\"/sitemap.xml\">\u003clink data-mint-head rel=\"alternate\" type=\"text/markdown\" href=\"/en/mcp.md\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"en\" href=\"https://docs.exploratory.io/en/mcp\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"ja\" href=\"https://docs.exploratory.io/ja/mcp\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"x-default\" href=\"https://docs.exploratory.io/en/mcp\">\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https://docs.exploratory.io/#organization\",\"name\":\"Exploratory\",\"url\":\"https://docs.exploratory.io\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https://mintcdn.com/exploratory-inc/t8wulpy3B474-b7T/en/markdown/images/logo_top.png?fit=max\u0026auto=format\u0026n=t8wulpy3B474-b7T\u0026q=85\u0026s=370661a35e27b492bc5d04396b5573fd\"}},{\"@type\":\"WebSite\",\"@id\":\"https://docs.exploratory.io#website\",\"name\":\"Exploratory\",\"url\":\"https://docs.exploratory.io\",\"publisher\":{\"@id\":\"https://docs.exploratory.io/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https://docs.exploratory.io/en/mcp#webpage\",\"url\":\"https://docs.exploratory.io/en/mcp\",\"name\":\"Exploratory MCP\",\"dateModified\":\"2026-11-18T07:00:28.879Z\",\"isPartOf\":{\"@id\":\"https://docs.exploratory.io#website\"},\"breadcrumb\":{\"@id\":\"https://docs.exploratory.io/en/mcp#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://docs.exploratory.io/en/mcp#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Exploratory\",\"item\":\"https://docs.exploratory.io/en\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Exploratory MCP\",\"item\":\"https://docs.exploratory.io/en/mcp\"}]},{\"@type\":[\"Article\",\"TechArticle\"],\"@id\":\"https://docs.exploratory.io/en/mcp#article\",\"headline\":\"Exploratory MCP\",\"name\":\"Exploratory MCP\",\"url\":\"https://docs.exploratory.io/en/mcp\",\"mainEntityOfPage\":{\"@id\":\"https://docs.exploratory.io/en/mcp#webpage\"},\"dateModified\":\"2026-11-18T07:00:28.879Z\",\"publisher\":{\"@id\":\"https://docs.exploratory.io/#organization\"},\"isPartOf\":{\"@id\":\"https://docs.exploratory.io#website\"}}]}\u003c/script>\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@type\":\"WebSite\",\"name\":\"Exploratory\",\"publisher\":{\"@type\":\"Organization\",\"name\":\"Exploratory\"},\"provider\":{\"@type\":\"Organization\",\"name\":\"Mintlify\",\"url\":\"https://mintlify.com\"}}\u003c/script>","agentPointerHref":"/en/mcp.md","siteName":"Exploratory","nav":{"global":null,"languages":[{"language":"en","default":true,"groups":[{"group":"Exploratory","pages":[{"title":"Exploratory Documentation","sidebarTitle":"Introduction","description":null,"href":"/en"},{"group":"Exploratory MCP","root":{"title":"Exploratory MCP","href":"/en/mcp"},"pages":[{"group":"Server","root":{"title":"Exploratory MCP: Server","sidebarTitle":"Server","description":null,"href":"/en/mcp/server"},"pages":[{"group":"Get started","root":{"title":"Get started","href":"/en/mcp/server/get-started"},"pages":[{"group":"Add from an AI tool","root":{"title":"Add from an AI tool","href":"/en/mcp/server/clients/apps"},"pages":[{"title":"Connect the Claude app","sidebarTitle":"Claude app","href":"/en/mcp/server/clients/claude"},{"title":"Connect the ChatGPT app","sidebarTitle":"ChatGPT app","href":"/en/mcp/server/clients/chatgpt"},{"title":"Connect Antigravity","sidebarTitle":"Antigravity","href":"/en/mcp/server/clients/antigravity"},{"title":"Connect Grok Bot","sidebarTitle":"Grok Bot","href":"/en/mcp/server/clients/grok-bot"},{"title":"Connect Claude Code","sidebarTitle":"Claude Code","href":"/en/mcp/server/clients/claude-code"},{"title":"Connect Codex","sidebarTitle":"Codex","href":"/en/mcp/server/clients/codex"},{"title":"Connect Cursor","sidebarTitle":"Cursor","href":"/en/mcp/server/clients/cursor"},{"title":"Connect other clients","sidebarTitle":"Other clients","href":"/en/mcp/server/clients/other"}]},{"title":"Authentication and API keys","href":"/en/mcp/server/auth"}]},{"title":"Use","description":null,"href":"/en/mcp/server/use"},{"group":"Reference","root":{"title":"Reference","href":"/en/mcp/server/reference"},"pages":[{"title":"Tools","href":"/en/mcp/server/tools"},{"title":"Limits and errors","href":"/en/mcp/server/limits"},{"title":"Data and permissions","href":"/en/mcp/server/data"}]},{"title":"Troubleshooting","description":null,"href":"/en/mcp/server/troubleshooting"}]},{"group":"Desktop","root":{"title":"Exploratory MCP: Desktop","sidebarTitle":"Desktop","href":"/en/mcp/desktop"},"pages":[{"group":"Get started","root":{"title":"Get started","href":"/en/mcp/desktop/get-started"},"pages":[{"title":"Install the plugin","href":"/en/mcp/desktop/install"},{"title":"Permissions and settings","href":"/en/mcp/desktop/permissions"}]},{"title":"Use","description":null,"href":"/en/mcp/desktop/use"},{"group":"Reference","root":{"title":"Reference","href":"/en/mcp/desktop/reference"},"pages":[{"title":"Tools","href":"/en/mcp/desktop/tools"},{"title":"Limits and errors","href":"/en/mcp/desktop/limits"},{"title":"Data and permissions","href":"/en/mcp/desktop/data"}]},{"title":"Troubleshooting","description":null,"href":"/en/mcp/desktop/troubleshooting"}]}]},{"group":"Exploratory CLI","root":{"title":"Exploratory CLI","href":"/en/cli"},"pages":[{"group":"Server","root":{"title":"Exploratory CLI: Server","sidebarTitle":"Server","href":"/en/cli/server"},"pages":[{"group":"Get started","root":{"title":"Get started","href":"/en/cli/server/get-started"},"pages":[{"title":"Installation","href":"/en/cli/server/install"},{"title":"Sign in","href":"/en/cli/server/login"},{"title":"API keys","href":"/en/cli/server/token"}]},{"group":"Use","root":{"title":"Use","href":"/en/cli/server/use"},"pages":[{"title":"Find data","href":"/en/cli/server/guides/find-data"},{"title":"Read notes","href":"/en/cli/server/guides/read-notes"},{"title":"Query data","href":"/en/cli/server/guides/query-data"},{"title":"Get chart numbers","href":"/en/cli/server/guides/dashboard-charts"},{"title":"Get analytics results","href":"/en/cli/server/guides/analytics"},{"title":"Save results to a file","href":"/en/cli/server/guides/export"},{"title":"Automation","href":"/en/cli/server/guides/automation"},{"title":"Use from AI agents","href":"/en/cli/server/guides/agents"}]},{"group":"Reference","root":{"title":"Reference","href":"/en/cli/server/reference"},"pages":[{"title":"All commands","href":"/en/cli/server/commands"},{"title":"Global flags","href":"/en/cli/server/global-flags"},{"title":"Exit codes and errors","href":"/en/cli/server/exit-codes"},{"title":"Data and permissions","href":"/en/cli/server/data"}]},{"title":"Troubleshooting","href":"/en/cli/server/troubleshooting"}]},{"group":"Desktop","root":{"title":"Exploratory CLI: Desktop","sidebarTitle":"Desktop","href":"/en/cli/desktop"},"pages":[{"group":"Get started","root":{"title":"Get started","href":"/en/cli/desktop/get-started"},"pages":[{"title":"Installation","href":"/en/cli/desktop/install"},{"title":"Choose a project","href":"/en/cli/desktop/guides/projects"}]},{"group":"Use","root":{"title":"Use","href":"/en/cli/desktop/use"},"pages":[{"title":"Import and wrangle data","href":"/en/cli/desktop/guides/wrangle-data"},{"title":"Create charts","href":"/en/cli/desktop/guides/create-charts"},{"title":"Create analytics","href":"/en/cli/desktop/guides/create-analytics"},{"title":"Write notes","href":"/en/cli/desktop/guides/write-notes"},{"title":"Duplicate dashboards","href":"/en/cli/desktop/guides/duplicate-dashboard"},{"title":"Publish","href":"/en/cli/desktop/guides/publish"},{"title":"Use from AI agents","href":"/en/cli/desktop/guides/agents"}]},{"group":"Reference","root":{"title":"Reference","href":"/en/cli/desktop/reference"},"pages":[{"title":"All commands","href":"/en/cli/desktop/commands"},{"title":"Global flags","href":"/en/cli/desktop/global-flags"},{"title":"Pass arguments and JSON","href":"/en/cli/desktop/guides/input"},{"title":"Output and language","href":"/en/cli/desktop/guides/output"},{"title":"Confirmation and long-running operations","href":"/en/cli/desktop/guides/confirmation"},{"title":"Exit codes and errors","href":"/en/cli/desktop/exit-codes"},{"title":"Data and permissions","href":"/en/cli/desktop/data"}]},{"title":"Troubleshooting","href":"/en/cli/desktop/troubleshooting"}]}]},{"group":"Product Features","root":{"title":"Product Features","href":"/en/product-features"},"pages":[{"title":"Summary View","href":"/en/summary/summary"},{"title":"Table View","href":"/en/table"},{"title":"Row Filter","href":"/en/table/row_filter"},{"title":"Column Filter","href":"/en/table/column_filter"},{"title":"Dashboard","href":"/en/markdown/markdown-dashboard"},{"title":"Note","href":"/en/markdown/markdown-note"},{"title":"Reproducible Steps","sidebarTitle":"Steps (Right-hand side)","href":"/en/steps"},{"title":"Branch feature","sidebarTitle":"Branch","href":"/en/branch"},{"title":"Parameter","href":"/en/parameter"},{"title":"Export Data","sidebarTitle":"Export","href":"/en/export"},{"group":"Share","root":{"title":"Share","href":"/en/share"},"pages":[{"title":"Share Type","href":"/en/share/share_type"},{"title":"Sharing Chart/Analytics","sidebarTitle":"Chart / Analytics","href":"/en/share/chart"},{"title":"Sharing Data","sidebarTitle":"Data","href":"/en/share/data"},{"title":"How to Share Report (Note or Dashboard)","sidebarTitle":"Report (Note / Dashboard)","href":"/en/share/note"},{"title":"Notification","href":"/en/share/notification"},{"title":"Version History","href":"/en/share/version-history"},{"title":"Restore Old Version","sidebarTitle":"Restore Older Version","href":"/en/share/restore"},{"title":"CSV API","href":"/en/share/csvapi"}]},{"group":"Schedule","root":{"title":"FAQ / Troubleshooting","sidebarTitle":"Schedule","href":"/en/schedule"},"pages":[{"title":"Publish Insights","sidebarTitle":"Manage Schedules","href":"/en/schedule/manage"},{"title":"Notification","href":"/en/schedule/notification"},{"title":"Scheduling History","href":"/en/schedule/history"}]},{"group":"Team","root":{"title":"Team","href":"/en/team"},"pages":[{"title":"Manage Teams","href":"/en/team/manage"}]},{"group":"Project","root":{"title":"Project","href":"/en/project"},"pages":[{"title":"How to import Project","sidebarTitle":"Import","href":"/en/project/import"},{"title":"How to export Project","sidebarTitle":"Export","href":"/en/project/export"},{"title":"How to search the Project","sidebarTitle":"Search","href":"/en/project/search"}]}]},{"group":"AI","root":{"title":"AI","href":"/en/ai"},"pages":[{"title":"AI Prompt Function","sidebarTitle":"AI Prompt Function","href":"/en/ai/ai-promtpt-function-en"}]},{"group":"Data Import","root":{"title":"Data Import","href":"/en/data_import"},"pages":[{"group":"File Data","root":{"title":"File Data","href":"/en/file-data"},"pages":[{"title":"Import CSV / Delimited File Data","sidebarTitle":"CSV / Delimited File","href":"/en/import/csv"},{"title":"Import CSV / Delimited File or Excel File or Parquet File Data from Amazon S3","sidebarTitle":"Amazon S3","href":"/en/import/s3"},{"title":"Import CSV / Delimited File or Excel File Data from Google Drive","sidebarTitle":"Google Drive","href":"/en/import/google-drive"},{"title":"Import CSV / Delimited File or Excel File Data from Google Cloud Storage (To be Introduced)","sidebarTitle":"Google Cloud Storage","href":"/en/import/google-cloud-storage"},{"title":"Import Excel File Data","sidebarTitle":"Excel","href":"/en/import/excel"},{"title":"Import JSON Data","sidebarTitle":"JSON","href":"/en/import/json"},{"title":"Import Log File Data","sidebarTitle":"Log File","href":"/en/import/log"},{"title":"Microsoft Azure Data Import","sidebarTitle":"Microsoft Azure","href":"/en/import/azure"},{"title":"Import Stats (SAS / SPSS / STAT) File Data","sidebarTitle":"Stats - SAS / SPSS / STATA","href":"/en/import/stats"},{"title":"Import R File (RDATA, RDS) File Data","sidebarTitle":"RData / RDS","href":"/en/import/rds"},{"title":"Import Parquet File Data","sidebarTitle":"Parquet File","href":"/en/import/parquet"},{"title":"Import Exploratory (EDF) File Data","sidebarTitle":"EDF - Exploratory","href":"/en/import/exploratory"}]},{"group":"Database Data","root":{"title":"Database Data","href":"/en/database-data"},"pages":[{"title":"SQL Troubleshooting","url":"https://exploratory.io/note/2ac8ae888097/How-to-workaround-the-issue-that-scheduled-Amazon-Athena-Data-Source-ends-up-with-empty-result-Fbe1yiQ3aC","href":"/en/external-sql-troubleshooting"},{"title":"Database Connection","sidebarTitle":"Create Connection","href":"/en/import/connection.html"},{"title":"Athena Data Import","sidebarTitle":"Amazon Athena","href":"/en/import/athena"},{"title":"Aurora Data Import","sidebarTitle":"Amazon Aurora","href":"/en/import/aurora"},{"title":"Amazon Redshift Database Data Import","sidebarTitle":"Amazon Redshift","href":"/en/import/redshift"},{"title":"Google BigQuery Data Import","sidebarTitle":"Google BigQuery","href":"/en/import/google-bigquery"},{"title":"HP Vertica Database Data Import","sidebarTitle":"HP Vertica","href":"/en/import/hp-vertica"},{"title":"MariaDB (MySQL) Data Import","sidebarTitle":"MariaDB / MySQL DB","href":"/en/import/mysql"},{"title":"MS Access Data Import","sidebarTitle":"Microsoft Access","href":"/en/import/access"},{"title":"MongoDB Data Import","sidebarTitle":"MongoDB","href":"/en/import/mongodb"},{"title":"ODBC Database Data Import","sidebarTitle":"ODBC","href":"/en/import/odbc"},{"title":"Oracle Database Data Import","sidebarTitle":"Oracle","href":"/en/import/oracle"},{"title":"Oracle Database Data Import (OCI)","sidebarTitle":"Oracle (OCI)","href":"/en/import/oracle-oci"},{"title":"PostgreSQL Database Data Import","sidebarTitle":"PostgreSQL","href":"/en/import/postgresql"},{"title":"Presto Data Import","sidebarTitle":"Presto","href":"/en/import/presto"},{"title":"Snowflake Data Import","sidebarTitle":"Snowflake","href":"/en/import/snowflake"},{"title":"SQLServer Data Import","sidebarTitle":"SQLServer (DSN)","href":"/en/import/sqlserver"},{"title":"SQL Server Data Import","sidebarTitle":"SQLServer","href":"/en/import/mssqlserver"},{"title":"Teradata Data Import","sidebarTitle":"Teradata","href":"/en/import/teradata"},{"title":"Treasure Data Import","sidebarTitle":"Treasure Data","href":"/en/import/treasuredata"}]},{"group":"Cloud Apps Data","root":{"title":"Cloud Apps Data","href":"/en/cloud-apps-data"},"pages":[{"title":"Connections for Cloud Apps","sidebarTitle":"Create Connection","href":"/en/import/connection-cloud-apps"},{"title":"FRED (Federal Reserve of Economic Data) Data Import","sidebarTitle":"FRED - Federal Reserve of Economic Data","href":"/en/import/fred"},{"title":"Github Issue Data Import","sidebarTitle":"Github Issues","href":"/en/import/github"},{"title":"Google Analytics Data","sidebarTitle":"Google Analytics","href":"/en/import/google-analytics"},{"title":"Google Spreadsheet Data Import","sidebarTitle":"Google Spreadsheet","href":"/en/import/google-sheet"},{"title":"Salesforce Data Import","sidebarTitle":"Salesforce","href":"/en/import/salesforce"},{"title":"Import Twitter Search API data","sidebarTitle":"Twitter Search","href":"/en/import/twitter"},{"title":"Import Stripe API Data","sidebarTitle":"Stripe","href":"/en/import/stripe"},{"title":"Whether Data Import","sidebarTitle":"Weather Data","href":"/en/import/weather"},{"title":"Stock Price Data","href":"/en/import/stock-price"},{"title":"Reinfolib","href":"/en/import/reinfolib"},{"title":"Estat","href":"/en/import/estat"},{"title":"Edinet","href":"/en/import/edinet"},{"title":"API","href":"/en/import/api"}]},{"group":"Write R Script as Data","root":{"title":"Write R Script to Get Data","sidebarTitle":"Write R Script as Data","href":"/en/import/r-script-data"},"pages":[{"title":"Currency Exchange Rate Data","sidebarTitle":"Currency Exchange Rate","href":"/en/import/currency"}]},{"title":"Import Data by Web Scraping","sidebarTitle":"Web Page Scraping","href":"/en/import/web-scraping"},{"title":"Text Input Data","href":"/en/import/free-input-text"},{"group":"Data Source Extension","root":{"title":"Data Source Extension","href":"/en/import/extensions"},"pages":[{"title":"Quandl Data Import","sidebarTitle":"Quandl","href":"/en/import/quandl"},{"title":"Holiday Data Import","sidebarTitle":"Holiday","href":"/en/import/holiday"},{"title":"RSS Data Import","sidebarTitle":"RSS Data","href":"/en/import/tidyrss"}]},{"title":"Add your Custom Data Sources with Data Source Extension Framework","sidebarTitle":"Create Custom Data Source","href":"/en/import/user-defined-plugin"}]},{"group":"Data Wrangling","root":{"title":"Data Wrangling","href":"/en/data-wrangling"},"pages":[{"title":"Command Line Mode","sidebarTitle":"Command Line mode for faster and more flexible data interaction in Exploratory","href":"/en/wrangling/command-mode"},{"title":"Select / Remove Columns","href":"/en/wrangling/select"},{"title":"Reorder Columns","href":"/en/wrangling/reorder"},{"title":"Create New Calculation","href":"/en/wrangling/mutate"},{"title":"Create New Calculation for Multiple Columns","href":"/en/wrangling/mutate_at"},{"title":"Summarize (Aggregate)","href":"/en/wrangling/summarize"},{"title":"Group Rows","sidebarTitle":"Group","href":"/en/wrangling/group"},{"title":"Filter","href":"/en/wrangling/filter"},{"title":"Rename","href":"/en/wrangling/rename"},{"title":"Arrange (Sort)","href":"/en/wrangling/arrange"},{"title":"Top / Bottom N","href":"/en/wrangling/top_n"},{"title":"Join Data","sidebarTitle":"Join","href":"/en/wrangling/join"},{"title":"Merge multiple Data Frames","sidebarTitle":"Merge","href":"/en/wrangling/merge"},{"title":"Gather (Unpivot)","sidebarTitle":"Gather","href":"/en/wrangling/gather"},{"title":"Spread","href":"/en/wrangling/spread"},{"title":"Pivot","href":"/en/wrangling/pivot"},{"title":"Expand","href":"/en/wrangling/expand"},{"title":"Complete","href":"/en/wrangling/complete"},{"title":"Separate","href":"/en/wrangling/separate"},{"title":"Unite","href":"/en/wrangling/unite"},{"title":"Bind Rows","href":"/en/wrangling/bind_rows"},{"title":"Bind Columns","href":"/en/wrangling/bind_columns"},{"title":"Keep Only Unique Rows","href":"/en/wrangling/distinct"},{"title":"Keep Only Duplicated Rows","href":"/en/wrangling/get_dupes"},{"title":"Slice","href":"/en/wrangling/slice"},{"title":"Drop NA","href":"/en/wrangling/drop_na"},{"title":"Sample","href":"/en/wrangling/sample"},{"title":"Impute NA","href":"/en/wrangling/impute_na"},{"title":"Fill","href":"/en/wrangling/fill"},{"title":"Create Buckets","href":"/en/wrangling/buckets"},{"title":"Assign New Values to Existing Values - Recode","href":"/en/wrangling/recode"},{"title":"Assign New Values by Setting Conditions - Case When","href":"/en/wrangling/case_when"},{"title":"Working with Categorical Data","sidebarTitle":"Work with Categories","href":"/en/wrangling/categories"},{"title":"Type Convert","sidebarTitle":"Data Type Conversion","href":"/en/wrangling/type-convert"},{"title":"Row as Header","sidebarTitle":"Row as header","href":"/en/wrangling/row_as_header"},{"title":"Ungroup","href":"/en/wrangling/ungroup"},{"title":"Unnest","href":"/en/wrangling/unnest"},{"title":"Separate List Items into Columns (Unnest Wider)","href":"/en/wrangling/unnest_wider"},{"title":"Separate List Items into Rows (Unnest Longer)","href":"/en/wrangling/unnest_longer"},{"title":"Separate Address (Japan)","href":"/en/wrangling/separate-japanese-address"},{"title":"Hoist","href":"/en/wrangling/hoist"},{"title":"Remove Empty Rows","href":"/en/wrangling/remove_empty_rows"},{"title":"Remove Empty Columns","href":"/en/wrangling/remove_empty_cols"},{"title":"Clean Column Names","href":"/en/wrangling/clean_names"},{"title":"Window (Table) Calculation","sidebarTitle":"Window Calculation","href":"/en/wrangling/window-calculation"},{"title":"Add Row","href":"/en/wrangling/add_row"},{"title":"Text Wrangling UI","sidebarTitle":"Text Wrangling","href":"/en/wrangling/text_wrangling"},{"title":"Regular Expression","sidebarTitle":"Regular Expression Cheat Sheet","href":"/en/wrangling/regular_expression"}]},{"group":"Visualization","root":{"title":"Visualization","href":"/en/visualization"},"pages":[{"group":"Types","pages":[{"title":"Pivot Table","sidebarTitle":"Pivot","href":"/en/viz/pivot"},{"title":"Summarize Table","href":"/en/viz/summarize-table"},{"title":"Table","href":"/en/viz/table"},{"title":"Bar Chart","sidebarTitle":"Bar","href":"/en/viz/bar"},{"title":"Line Chart","sidebarTitle":"Line","href":"/en/viz/line"},{"title":"Area Chart","sidebarTitle":"Area","href":"/en/viz/area"},{"title":"Pie / Ring Chart","sidebarTitle":"Pie/Ring","href":"/en/viz/pie"},{"title":"Radar Chart","sidebarTitle":"Radar","href":"/en/viz/radar"},{"title":"Histogram Chart","sidebarTitle":"Histogram","href":"/en/viz/hist"},{"title":"Density Plot","href":"/en/viz/densityplot"},{"title":"Scatter (No Aggregation) Chart","sidebarTitle":"Scatter (No Aggregation)","href":"/en/viz/scatter"},{"title":"Scatter (With Aggregation) Chart","sidebarTitle":"Scatter (With Aggregation)","href":"/en/viz/bubble"},{"title":"Boxplot Chart","sidebarTitle":"Boxplot","href":"/en/viz/boxplot"},{"title":"Violin Chart","sidebarTitle":"Violin","href":"/en/viz/violin"},{"title":"Error Bar Chart","sidebarTitle":"Error Bar","href":"/en/viz/errbar"},{"title":"Error Bar (Summarized Data) Chart","sidebarTitle":"Error Bar (Summarized Data)","href":"/en/viz/errbar-agg"},{"title":"Map - Standard","href":"/en/viz/easymap"},{"title":"Map - Extension","href":"/en/viz/geojson"},{"title":"Map - Long / Lat","sidebarTitle":"Map - Long/Lat","href":"/en/viz/map"},{"title":"Map - Heatmap","href":"/en/viz/maphmap"},{"title":"Heatmap","href":"/en/viz/heatmap"},{"title":"Contour","href":"/en/viz/contour"},{"title":"Number Chart","sidebarTitle":"Number","href":"/en/viz/singlevalue"},{"title":"Word Cloud","href":"/en/viz/wordcloud"},{"title":"Custom (R)","href":"/en/viz/r-custom"}]},{"group":"Features","pages":[{"title":"Trend Line","href":"/en/viz/trend-line"},{"title":"Reference Line","href":"/en/viz/reference-line"},{"title":"Repeat By","href":"/en/viz/small-multiple"},{"title":"Window (Table) Calculation","sidebarTitle":"Window Calculation","href":"/en/viz/window-calc"},{"title":"Date / Time Aggregation","sidebarTitle":"Date/Time Aggregation","href":"/en/viz/date-aggregate"},{"title":"Range","sidebarTitle":"Show Range","href":"/en/viz/range"},{"title":"Marker Type","sidebarTitle":"Change Marker","href":"/en/viz/marker"},{"title":"Multiple Y-Axis","sidebarTitle":"Multiple Y-Axis Columns","href":"/en/viz/multi-y"},{"title":"Configure Layout and Format","sidebarTitle":"Layout Configuration","href":"/en/viz/layout"},{"title":"Select and Configure Columns","sidebarTitle":"Column Configuration","href":"/en/viz/column-configuration"},{"title":"Column Configuration Dialog","href":"/en/viz/column-configuration-dialog"},{"title":"Color \u0026 Group Setting","sidebarTitle":"Color and Group Setting","href":"/en/viz/color"},{"title":"Color setting","sidebarTitle":"Color Setting","href":"/en/viz/color-dialog"},{"title":"User Color Palette","sidebarTitle":"User Color Palette Setting","href":"/en/viz/custom-palette"},{"title":"Chart Pinning","sidebarTitle":"Pin","href":"/en/viz/pin"},{"title":"Save Chart as PNG / SVG","sidebarTitle":"Save as PNG/SVG","href":"/en/viz/save"},{"title":"Export Chart as EDF (Exploratory Data File)","sidebarTitle":"Save as Exploratory Data File","href":"/en/viz/save-as-edf"},{"title":"Share / Schedule","sidebarTitle":"Share/Schedule","href":"/en/viz/schedule"},{"title":"URL Link","href":"/en/viz/urllink"},{"title":"Category (Binning)","href":"/en/viz/category"},{"title":"Highlight","href":"/en/viz/highlight"},{"title":"Limit Values","href":"/en/viz/limit"},{"title":"'Others' Group","sidebarTitle":"'Others' Group","href":"/en/viz/others-group"},{"title":"Edit Display Names","sidebarTitle":"Edit Display Name","href":"/en/viz/edit-display-name"},{"title":"Missing Value Handling","href":"/en/viz/missing-value-handling"},{"title":"Rename Column Names","href":"/en/viz/rename-column-names"},{"title":"Axis Setting","href":"/en/viz/dualy-setting"},{"title":"Axis Formatting","href":"/en/viz/axis-format"},{"title":"Show Detail","href":"/en/viz/show-detail"},{"title":"Fit to Screen","sidebarTitle":"Fit to Screen (Table)","href":"/en/viz/table-fit-to-screen"},{"title":"Number of Unique Values Check","href":"/en/viz/number-of-unuque-values-check"}]}]},{"group":"Analytics","root":{"title":"Instant Analytics UI","sidebarTitle":"Analytics","href":"/en/analytics"},"pages":[{"title":"Correlation by Column","sidebarTitle":"Correlation","href":"/en/analytics/correlation_column"},{"title":"Distance by Columns Analytics View","sidebarTitle":"Distance","href":"/en/analytics/distance_column"},{"title":"K-Means Clustering Analytics View","sidebarTitle":"K-Means Clustering","href":"/en/analytics/kmeans"},{"title":"K-Modes Clustering Analytics View","sidebarTitle":"K-Modes Clustering","href":"/en/analytics/kmodes"},{"title":"Principal Component Analysis Analytics View","sidebarTitle":"Principal Component Analysis","href":"/en/analytics/pca"},{"title":"Factor Analysis","href":"/en/analytics/factanal"},{"title":"Correspondence Analysis","href":"/en/analytics/correspondence"},{"title":"Regression Analysis","sidebarTitle":"Linear Regression Analysis","href":"/en/analytics/regression"},{"title":"Logistic Regression Analytics View","sidebarTitle":"Logistic Regression Analysis","href":"/en/analytics/logistic"},{"title":"Ordered Logistic Regression Analytics View","sidebarTitle":"Ordered Logistic Regression Analysis","href":"/en/analytics/ordered_logistic_regression"},{"title":"Generalized Linear Model (GLM) Analytics View","sidebarTitle":"Generalized Linear Models","href":"/en/analytics/glm"},{"title":"Survival Analysis","sidebarTitle":"Survival Curve","href":"/en/analytics/survival"},{"title":"Cox Regression Analytics","sidebarTitle":"Cox Regression","href":"/en/analytics/var_importance_time"},{"title":"Random Survival Forest","href":"/en/analytics/survival_forest"},{"title":"Decision Tree Analytics View","sidebarTitle":"Decision Tree","href":"/en/analytics/decision_tree"},{"title":"CHAID Analytics View","sidebarTitle":"CHAID","href":"/en/analytics/chaid"},{"title":"Random Forest","href":"/en/analytics/var_importance"},{"title":"XGBoost","href":"/en/analytics/xgboost"},{"title":"LightGBM","href":"/en/analytics/lightgbm"},{"title":"Time Series Forecasting","sidebarTitle":"Time Series Forecasting (Prophet)","href":"/en/analytics/forecasting"},{"title":"Time Series Forecasting (ARIMA)","href":"/en/analytics/arima"},{"title":"Time Series Clustering","href":"/en/analytics/time_series_clustering"},{"title":"Anomaly Detection","href":"/en/analytics/anomaly"},{"title":"Text Analysis","sidebarTitle":"Word Count","href":"/en/analytics/textanal"},{"title":"Text Clustering with Topic Model","sidebarTitle":"Text Clustering with Topic Model (LDA)","href":"/en/analytics/topic_model"},{"title":"Market Basket Analysis Analytics View","sidebarTitle":"Market Basket Analysis","href":"/en/analytics/market_basket"},{"title":"T Test Analytics View","sidebarTitle":"T Test","href":"/en/analytics/t_test"},{"title":"T Test Analytics View for Aggregated Data","sidebarTitle":"T Test (Aggregated Data)","href":"/en/analytics/t_test_aggregated"},{"title":"ANOVA Analytics","sidebarTitle":"ANOVA","href":"/en/analytics/anova"},{"title":"Wilcoxon Test Analytics View","sidebarTitle":"Wilcoxon Test","href":"/en/analytics/wilcoxon"},{"title":"Kruskal-Wallis Test Analytics View","sidebarTitle":"Kruskal-Wallis Test","href":"/en/analytics/kruskal_wallis"},{"title":"Chi-Square Test Analytics View","sidebarTitle":"Chi-Square Test","href":"/en/analytics/chisq"},{"title":"A/B Test - Bayesian","sidebarTitle":"A/B Test","href":"/en/analytics/ab_test"},{"title":"Normality Test Analytics View","sidebarTitle":"Normality Test","href":"/en/analytics/normality"},{"title":"Cronbach's Alpha Analytics View","sidebarTitle":"Cronbach's Alpha","href":"/en/analytics/cronbach-alpha"},{"title":"Prediction with a Model from Analytics View","sidebarTitle":"Prediction","href":"/en/analytics/prediction"},{"title":"How to manage Dictionaries","sidebarTitle":"Dictionaries for Text Analysis","href":"/en/analytics/dictionary"}]},{"group":"Statistics","root":{"title":"Statistics","href":"/en/statistics"},"pages":[{"title":"Correlation","href":"/en/stats/correlation"},{"title":"Distance","href":"/en/stats/dist"},{"title":"Cosine Similarity","href":"/en/stats/sim"},{"title":"SVD","href":"/en/stats/svd"},{"title":"Multi Dimensional Scaling","href":"/en/stats/mds"},{"title":"T-test","href":"/en/stats/t-test"},{"title":"F-test","href":"/en/stats/f-test"},{"title":"Chi Squared Test","sidebarTitle":"Chi-square test","href":"/en/stats/chi-test"},{"title":"A/B Test (Bayesian)","href":"/en/stats/exp_bayes_ab"}]},{"group":"Machine Learning","root":{"title":"Machine Learning","href":"/en/machine-learning"},"pages":[{"title":"Linear Regression Model","sidebarTitle":"Linear Regression","href":"/en/ml/linear-regression"},{"title":"Logistic Regression Model","sidebarTitle":"Logistic Regression","href":"/en/ml/logistic-regression"},{"title":"Generalized Linear Regression Model","sidebarTitle":"GLM","href":"/en/ml/glm"},{"title":"Multinomial Logistic Regression Model","sidebarTitle":"Multinomial Logistic Regression","href":"/en/ml/multinom"},{"title":"K-means Clustering Model","sidebarTitle":"K-means Clustering","href":"/en/ml/kmeans"},{"title":"Random Forest Model","sidebarTitle":"Random Forest","href":"/en/ml/random-forest"},{"title":"XGBoost - Extreme Gradient Boosting","sidebarTitle":"XGBoost","href":"/en/ml/xgboost"},{"title":"Time Series Forecasting","sidebarTitle":"Forecasting","href":"/en/ml/forecasting"},{"title":"Time Series Clustering","href":"/en/ml/timeseries_clustering"},{"title":"Anomaly Detection","href":"/en/ml/anomaly"},{"title":"Calculate Survival Curve","sidebarTitle":"Survival Curve","href":"/en/ml/survival-curv"},{"title":"Survival Analysis - Cox Regression / Proportional Hazard","sidebarTitle":"Survival Model (Cox Regression)","href":"/en/ml/cox-regression"},{"title":"Market Basket Analysis - Association Rules","sidebarTitle":"Market Basket","href":"/en/ml/arules"},{"title":"Causal Impact Analysis","sidebarTitle":"Causal Impact","href":"/en/ml/causal_impact"},{"title":"Evaluate Prediction - Regression","href":"/en/ml/evaluate_regression"},{"title":"Evaluate Prediction - Binary","href":"/en/ml/evaluate_binary"},{"title":"Calculate ROC","href":"/en/ml/do_roc"},{"title":"Evaluate Prediction - Multiclass","href":"/en/ml/evaluate_multi"},{"title":"Predict Data","sidebarTitle":"Prediction","href":"/en/ml/prediction"},{"title":"Predict Data - Binary","sidebarTitle":"Prediction - Binary Classification","href":"/en/ml/prediction_binary"},{"title":"Predict Data - Survival","sidebarTitle":"Prediction - Survival Model","href":"/en/ml/prediction_coxph"},{"title":"Simulate Survival Curve","href":"/en/ml/prediction_survfit"},{"title":"Summary of Fit","sidebarTitle":"Extract Summary of Fit","href":"/en/ml/model_stats"},{"title":"Extract Parameter Estimates","href":"/en/ml/model_coef"},{"title":"Run ANOVA Test","href":"/en/ml/model_anova"},{"title":"Fix Imbalanced Data","sidebarTitle":"Fix Imbalanced Data (SMOTE)","href":"/en/wrangling/smote"}]},{"group":"Text Analysis","root":{"title":"Text Mining in Exploratory","sidebarTitle":"Text Analysis","href":"/en/text/main"},"pages":[{"title":"Tokenize Text","href":"/en/text/do_tokenize"},{"title":"Create N-gram Tokens","href":"/en/text/do_ngram"},{"title":"Calculate TF-IDF","sidebarTitle":"Calculate tf-idf","href":"/en/text/do_tfidf"},{"title":"Count Text Pairs","href":"/en/text/pair_count"}]},{"group":"Extend with R","root":{"title":"Extend with R","href":"/en/extend-with-r"},"pages":[{"title":"Install R Package","sidebarTitle":"R Package Install","href":"/en/r_package"},{"title":"Add your own custom R functions or variables with R Script","sidebarTitle":"Custom R Script","href":"/en/r_script"},{"title":"Use Custom Model Function","sidebarTitle":"Custom Model Function","href":"/en/user-defined-model-function"}]},{"group":"Setup","pages":[{"title":"How to disable McAfee Real Time Virus Scan temporarily for allowing Exploratory to install R packages.","sidebarTitle":"Disable McAfee virus scan","href":"/en/howto/stopmcafee"},{"title":"Change Repository Location","href":"/en/howto/set_exploratory_home"},{"title":"How to Set Holidays Data for Time Series Forecast","sidebarTitle":"Holidays Data for Forecast","href":"/en/howto/holiday"},{"title":"Possible Reasons for Installation Errors","sidebarTitle":"Possible Reasons for Install Error","href":"/en/howto/install_errors"},{"title":"How to Upgrade .NET Framework","sidebarTitle":"Upgrade Microsoft .NET Framework","href":"/en/howto/upgrade_dot_net"}]},{"group":"Diagnostics","pages":[{"title":"Log file for debugging","href":"/en/debug_log"},{"title":"Startup log file for debugging","sidebarTitle":"Startup Log file for debugging","href":"/en/startup_log"},{"title":"Check version of your Exploratory Desktop","sidebarTitle":"Check version of Exploratory Desktop","href":"/en/version_check"},{"title":"How to Recover the History Data","href":"/en/history_error_recovery"}]},{"title":"Keyboard shortcuts","href":"/en/shortcut"}]}]},{"language":"ja","pages":[{"title":"ja","href":"/ja/mcp"}]}]},"basePath":"","title":"Exploratory MCP - Exploratory","deploymentId":"dpl_HhUetB7eHHDAmK9T1Teip38TgFx9","buildId":"dpl_HhUetB7eHHDAmK9T1Teip38TgFx9","dynamics":[],"chunks":[]}