Powerdrill
A Model Context Protocol (MCP) server that provides tools to interact with Powerdrill datasets, authenticated with Powerdrill User ID and Project API Key. Please go to https://chat.powerdrill.ai/ for AI data analysis individually or use with your Team. If you have the Powerdrill User ID and Project API Key of your Team, you can manipulate the data via Powerdrill open sourced web clients: - Node.js edtion: https://flow.powerdrill.ai/, or play with the open source web client https://github.com/powerdrillai/powerdrill-flow. - Python edtion: https://powerdrill-flow.streamlit.app/, or play with the open source web client https://github.com/powerdrillai/powerdrill-flow-streamlit.
Ads
Overview
A Model Context Protocol (MCP) server that provides tools to interact with Powerdrill datasets, authenticated with Powerdrill User ID and Project API Key. Please go to https://chat.powerdrill.ai/ for AI data analysis individually or use with your Team. If you have the Powerdrill User ID and Project API Key of your Team, you can manipulate the data via Powerdrill open sourced web clients: - Node.js edtion: https://flow.powerdrill.ai/, or play with the open source web client https://github.com/powerdrillai/powerdrill-flow. - Python edtion: https://powerdrill-flow.streamlit.app/, or play with the open source web client https://github.com/powerdrillai/powerdrill-flow-streamlit.
Capabilities
- mcp_powerdrill_list_datasets
List your Powerdrill datasets — Ask the assistant to show available datasets using `mcp_powerdrill_list_datasets`.
- mcp_powerdrill_get_dataset_overview
Get a dataset overview — Retrieve structure, summary, and suggested exploration questions with `mcp_powerdrill_get_dataset_overview`.
- mcp_powerdrill_create_job
Analyze data with natural language — Submit a question against a dataset and get code, tables, charts, and text via `mcp_powerdrill_create_job`.
- mcp_powerdrill_create_data_source_from_local_file
Upload a local file to a dataset — Add a CSV, Excel, or PDF from your machine using `mcp_powerdrill_create_data_source_from_local_file`.
- mcp_powerdrill_create_dataset
Create a new dataset — Provision a named dataset in your account with `mcp_powerdrill_create_dataset`.
- mcp_powerdrill_create_session
Manage analysis sessions — Create sessions with `mcp_powerdrill_create_session` and list existing ones with `mcp_powerdrill_list_sessions`.
Installation
npx -y @smithery/cli install @powerdrillai/powerdrill-mcp --client claude
Configuration
{
"mcpServers": {
"powerdrill-mcp": {
"command": "npx",
"args": [
"-y",
"@powerdrillai/powerdrill-mcp"
]
}
}
}Paste into ~/.cursor/mcp.json or .cursor/mcp.json
Tags
- data-analysis
- database
- ai-agent
Related MCP servers
Databases
InstantDB
This MCP is a wrapper around the Instant Platform SDK. Add this MCP to your editor to enable creating, managing, and updating your InstantDB applications. Instant hosts the latest version of the server at https://mcp.instantdb.com. For modern clients that support streamable HTTP use https://mcp.instantdb.com/mcp. For legacy clients that require SSE use https://mcp.instantdb.com/sse. For more editor-specific instructions, see the public docs. If you haven't already, make sure to get a personal access token from your Instant dashboard.
3 tools · Connect via remote or local server, Create and manage InstantDB apps
Databases
Jitsu
Jitsu collects event data from your websites, apps and servers, and delivers it to your data warehouse and to whatever other tools you use. It covers the same ground as Segment, but it's MIT-licensed and self-hostable, so the whole pipeline can run inside your own infrastructure — or on Jitsu Cloud, same software, hosted. Data lands in minutes, not hours: Segment loads warehouses once or twice a day (hourly at best), while Jitsu delivers per destination in batches as frequent as a minute, or row-by-row where that suits the destination. And where Segment bills by Monthly Tracked User, Jitsu Cloud bills by event volume, so the bill tracks data rather than audience size — while self-hosting has no usage billing at all.
4 tools · Configure destinations and streams, Debug pipelines with Live Events
Databases
Financial Datasets
This is a Model Context Protocol (MCP) server that provides access to stock market data from Financial Datasets. It allows Claude and other AI assistants to retrieve income statements, balance sheets, cash flow statements, stock prices, and market news directly through the MCP interface. This MCP server provides the following tools: - get_income_statements: Get income statements for a company. - get_balance_sheets: Get balance sheets for a company. - get_cash_flow_statements: Get cash flow statements for a company. - get_current_stock_price: Get the current / latest price of a company. - get_historical_stock_prices: Gets historical stock prices for a company. - get_company_news: Get news for a company. - get_available_crypto_tickers: Gets all available crypto tickers. - get_crypto_prices: Gets historical prices for a crypto currency. - get_historical_crypto_prices: Gets historical prices for a crypto currency. - get_current_crypto_price: Get the current / latest price of a crypto curre
6 tools · get_balance_sheets, get_cash_flow_statements
Databases
pg-aiguide
AI-optimized PostgreSQL expertise for coding assistants pg-aiguide helps AI coding tools write dramatically better PostgreSQL code. It provides: - Semantic search across the official PostgreSQL manual (version-aware) - AI-optimized “skills” — curated, opinionated Postgres best practices used automatically by AI agents - Extension ecosystem docs, starting with TimescaleDB, with more coming soon - Agent Skills via npx skills — works with Claude Code, Cursor, Codex, Gemini CLI, and 40+ other agents - a public MCP server that can be used with any AI coding agent, or - a Claude Code plugin optimized for use with Claude's native skill support.
3 tools · search_docs, tiger
Databases
MotherDuck
Connect AI assistants to your data using DuckDB's powerful analytical SQL engine. Supports connecting to local DuckDB files, in-memory databases, S3-hosted databases, and MotherDuck. Allows executing SQL read- and write-queries, browsing database catalogs, and switching between different database connections on-the-fly. Looking for a fully-managed remote MCP server for MotherDuck? → Go to the MotherDuck Remote MCP docs > 📝 Migrating from v0.x? > - Read-only by default: The server now runs in read-only mode by default. Add --read-write to enable write access. See Securing for Production. > - Default database changed: --db-path default changed from md: to :memory:. Add --db-path md: explicitly for MotherDuck. > - MotherDuck read-only requires read-scaling token: MotherDuck connections in read-only mode require a read-scaling token. Regular tokens require --read-write.
5 tools · Connect to MotherDuck for cloud analytics, Control query output size
Databases
Apache Doris
http://www.apache.org/licenses/LICENSE-2.0 Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License. --> Apache Doris MCP Server exposes read-only Apache Doris capabilities to MCP Hosts and AI agents over MCP 2026-07-28. Version 1.0 replaces a large flat tool surface with eight stable domains and fifty-five progressively disclosed child capabilities, while keeping runtime availability, authorization, input schemas, output schemas, and failure behavior explicit.
6 tools · doris_catalog, doris_cluster
Databases
StarRocks
The StarRocks MCP Server acts as a bridge between AI assistants and StarRocks databases. It allows for direct SQL execution, database exploration, data visualization via charts, and retrieving detailed schema/data overviews without requiring complex client-side setup. - Direct SQL Execution: Run SELECT queries (read_query) and DDL/DML commands (write_query). - Database Exploration: List databases and tables, retrieve table schemas (starrocks:// resources). - System Information: Access internal StarRocks metrics and states via the proc:// resource path. - Detailed Overviews: Get comprehensive summaries of tables (table_overview) or entire databases (db_overview), including column definitions, row counts, and sample data. - Data Visualization: Execute a query and generate a Plotly chart directly from the results (query_and_plotly_chart). - Intelligent Caching: Table and database overviews are cached in memory to speed up repeated requests. Cache can be bypassed when needed. - Flexible Co
6 tools · Explore database schemas, query_and_plotly_chart
Databases
OceanBase
Model Context Protocol (MCP) Server Collection for OceanBase Ecosystem awesome-oceanbase-mcp is a Model Context Protocol (MCP) server repository specifically designed for the OceanBase ecosystem. 🎯 Mission: Enable AI assistants to interact directly with OceanBase databases and ecosystem components through standardized MCP protocols. ✨ Core Values: - 🤖 AI-Friendly: Direct database operations within Claude, ChatGPT and other AI assistants - 🔒 Secure & Reliable: Provides safe database access and operation mechanisms - 🛠️ Complete Ecosystem: Covers the complete OceanBase product and tool chain - 🚀 Ready to Use: Simple configuration to get started
5 tools · Diagnose performance issues, Manage cloud database instances