Labsco
powerdrillai logo

Powerdrill

★ 13

from powerdrillai

An MCP server that provides tools to interact with Powerdrill datasets, enabling smart AI data analysis and insights.

🔥🔥🔥✓ VerifiedAccount requiredNeeds API keys
#automation#analytics#documents#git#weather#finance

Powerdrill MCP Server

smithery badge

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:

Features

  • Authenticate with Powerdrill using User ID and Project API Key
  • List available datasets in your Powerdrill account
  • Get detailed information about specific datasets
  • Create and run jobs on datasets with natural language questions
  • Integration with Claude Desktop and other MCP-compatible clients

Available Tools

mcp_powerdrill_list_datasets

Lists available datasets from your Powerdrill account.

Parameters:

  • limit (optional): Maximum number of datasets to return

Example response:

{
  "datasets": [
    {
      "id": "dataset-dasfadsgadsgas",
      "name": "mydata",
      "description": "my dataset"
    }
  ]
}

mcp_powerdrill_get_dataset_overview

Gets detailed overview information about a specific dataset.

Parameters:

  • datasetId (required): The ID of the dataset to get overview information for

Example response:

{
  "id": "dset-cm5axptyyxxx298",
  "name": "sales_indicators_2024",
  "description": "A dataset comprising 373 travel bookings with 15 attributes...",
  "summary": "This dataset contains 373 travel bookings with 15 attributes...",
  "exploration_questions": [
    "How does the booking price trend over time based on the BookingTimestamp?",
    "How does the average booking price change with respect to the TravelDate?"
  ],
  "keywords": [
    "Travel Bookings",
    "Booking Trends",
    "Travel Agencies"
  ]
}

mcp_powerdrill_create_job

Creates a job to analyze data with natural language questions.

Parameters:

  • question (required): The natural language question or prompt to analyze the data
  • dataset_id (required): The ID of the dataset to analyze
  • datasource_ids (optional): Array of specific data source IDs within the dataset to analyze
  • session_id (optional): Session ID to group related jobs
  • stream (optional, default: false): Whether to stream the results
  • output_language (optional, default: "AUTO"): The language for the output
  • job_mode (optional, default: "AUTO"): The job mode

Example response:

{
  "job_id": "job-cm3ikdeuj02zk01l1yeuirt77",
  "blocks": [
    {
      "type": "CODE",
      "content": "```python\nimport pandas as pd\n\ndef invoke(input_0: pd.DataFrame) -> pd.DataFrame:\n...",
      "stage": "Analyze"
    },
    {
      "type": "TABLE",
      "url": "https://static.powerdrill.ai/tmp_datasource_cache/code_result/...",
      "name": "trend_data.csv",
      "expires_at": "2024-11-21T09:56:34.290544Z"
    },
    {
      "type": "IMAGE",
      "url": "https://static.powerdrill.ai/tmp_datasource_cache/code_result/...",
      "name": "Trend of Deaths from Natural Disasters Over the Century",
      "expires_at": "2024-11-21T09:56:34.290544Z"
    },
    {
      "type": "MESSAGE",
      "content": "Analysis of Trends in the Number of Deaths from Natural Disasters...",
      "stage": "Respond"
    }
  ]
}

mcp_powerdrill_create_session

Creates a new session to group related jobs together.

Parameters:

  • name (required): The session name, which can be up to 128 characters in length
  • output_language (optional, default: "AUTO"): The language in which the output is generated. Options include: "AUTO", "EN", "ES", "AR", "PT", "ID", "JA", "RU", "HI", "FR", "DE", "VI", "TR", "PL", "IT", "KO", "ZH-CN", "ZH-TW"
  • job_mode (optional, default: "AUTO"): Job mode for the session. Options include: "AUTO", "DATA_ANALYTICS"
  • max_contextual_job_history (optional, default: 10): The maximum number of recent jobs retained as context for the next job (0-10)
  • agent_id (optional, default: "DATA_ANALYSIS_AGENT"): The ID of the agent

Example response:

{
  "session_id": "session-abcdefghijklmnopqrstuvwxyz"
}

mcp_powerdrill_list_data_sources

Lists data sources in a specific dataset.

Parameters:

  • datasetId (required): The ID of the dataset to list data sources from
  • pageNumber (optional, default: 1): The page number to start listing
  • pageSize (optional, default: 10): The number of items on a single page
  • status (optional): Filter data sources by status: synching, invalid, synched (comma-separated for multiple)

Example response:

{
  "count": 3,
  "total": 5,
  "page": 1,
  "page_size": 10,
  "data_sources": [
    {
      "id": "dsource-a1b2c3d4e5f6g7h8i9j0",
      "name": "sales_data.csv",
      "type": "CSV",
      "status": "synched",
      "size": 1048576,
      "dataset_id": "dset-cm5axptyyxxx298"
    },
    {
      "id": "dsource-b2c3d4e5f6g7h8i9j0k1",
      "name": "customer_info.xlsx",
      "type": "EXCEL",
      "status": "synched",
      "size": 2097152,
      "dataset_id": "dset-cm5axptyyxxx298"
    },
    {
      "id": "dsource-c3d4e5f6g7h8i9j0k1l2",
      "name": "market_research.pdf",
      "type": "PDF",
      "status": "synched",
      "size": 3145728,
      "dataset_id": "dset-cm5axptyyxxx298"
    }
  ]
}

mcp_powerdrill_list_sessions

Lists sessions from your Powerdrill account.

Parameters:

  • pageNumber (optional): The page number to start listing (default: 1)
  • pageSize (optional): The number of items on a single page (default: 10)
  • search (optional): Search for sessions by name

Example response:

{
  "count": 2,
  "total": 2,
  "sessions": [
    {
      "id": "session-123abc",
      "name": "Product Analysis",
      "job_count": 3,
      "created_at": "2024-03-15T10:30:00Z",
      "updated_at": "2024-03-15T11:45:00Z"
    },
    {
      "id": "session-456def",
      "name": "Financial Forecasting",
      "job_count": 5,
      "created_at": "2024-03-10T14:20:00Z",
      "updated_at": "2024-03-12T09:15:00Z"
    }
  ]
}

mcp_powerdrill_create_dataset

Creates a new dataset in your Powerdrill account.

Parameters:

  • name (required): The dataset name, which can be up to 128 characters in length
  • description (optional): The dataset description, which can be up to 128 characters in length

Example response:

{
  "id": "dataset-adsdfasafdsfasdgasd",
  "message": "Dataset created successfully"
}

mcp_powerdrill_create_data_source_from_local_file

Creates a new data source by uploading a local file to a specified dataset.

Parameters:

  • dataset_id (required): The ID of the dataset to create the data source in
  • file_path (required): The local path to the file to upload
  • file_name (optional): Custom name for the file, defaults to the original filename
  • chunk_size (optional, default: 5MB): Size of each chunk in bytes for multipart upload

Example response:

{
  "dataset_id": "dset-cm5axptyyxxx298",
  "data_source": {
    "id": "dsource-a1b2c3d4e5f6g7h8i9j0",
    "name": "sales_data_2024.csv",
    "type": "FILE",
    "status": "synched",
    "size": 2097152
  },
  "file": {
    "name": "sales_data_2024.csv",
    "size": 2097152,
    "object_key": "uploads/user_123/sales_data_2024.csv"
  }
}