powerdrillai powerdrill mcp

WHAT IT CONNECTS

What powerdrillai powerdrill mcp gives an AI Agent

• 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
• Sign up for a Powerdrill Team account if you haven't already
• Navigate to your account settings
• Look for the API section where you'll find your:
• User ID: A unique identifier for your account
• API Key: Your authentication token for API access
• Install dependencies
• Build the TypeScript code
• Create a `.env` file if it doesn't exist
• Generate configuration files for Claude Desktop and Cursor with the npx-based configuration (recommended)
• Open Claude Desktop
• Go to Settings > Server Settings
• Add a new server with one of the following configurations:
• Save the configuration
• Restart Claude Desktop
• Open Cursor
• Go to Settings > MCP Tools
• Add a new MCP tool with one of the following configurations:
• Save the configuration
• Restart Cursor if needed
• List datasets: `What datasets are available in my Powerdrill account?` or `Show me all my datasets`
• Create dataset: `Create a new dataset called "Sales Analytics"` or `Make a new dataset named "Customer Data" with description "Customer information for 2024 analysis"`
• Create data source from local file: `Upload the file /Users/your_name/Downloads/sales_data.csv to dataset {dataset_id}` or `Add my local file /path/to/customer_data.xlsx to my {dataset_id} dataset`
• Get dataset overview: `Tell me more about this dataset: {dataset_id}` or `Describe the structure of dataset {dataset_id}`
• Create a job: `Analyze dataset {dataset_id} with this question: "How has the trend changed over time?"` or `Run a query on {dataset_id} asking "What are the top 10 customers by revenue?"`
• Create a session: `Create a new session named "Sales Analysis 2024" for my data analysis` or `Start a session called "Customer Segmentation" for analyzing market data`
• List data sources: `What data sources are available in dataset {dataset_id}?` or `Show me all files in the {dataset_id} dataset`
• List sessions: `Show me all my current analysis sessions` or `List my recent data analysis sessions`
• `limit` (optional): Maximum number of datasets to return
• `datasetId` (required): The ID of the dataset to get overview information for
• `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
• `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
• `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)
• `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
• `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
• `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
• Make sure your environment variables are set correctly in `.env`
• Check that the server starts successfully with `npm start`
• Verify your Claude Desktop configuration points to the correct file paths
• Check the console output for any error messages