MCP App Store
by KeenEthics
Data-Analytics

Collation MCP Server

by Collation

Overview

Collation sets up and manages a dedicated data warehouse for your investment data, then connects Claude directly to it. Your portfolios, positions, transactions, and performance data stay in your own warehouse — Claude queries it in place so you get answers without exporting or moving anything. Ask questions in plain language and Claude will run SQL against your warehouse, pull up dashboards, and reuse your saved queries. Key capabilities: Run SQL and explore tables across your own data warehouse Calculate time-weighted returns (TWR) for any portfolio or period Access and build on your saved queries and dashboards Browse schema and documentation to understand what's available Built for wealth managers, analysts, and operations teams who want fast, accurate answers from investment data they fully own and control.

Tools

calculate_twr

Claude

create_saved_query

Claude

describe_table

Claude

get_dashboard

Claude

list_dashboards

Claude

list_databases

Claude

list_documentation

Claude

list_saved_queries

Claude

list_tables

Claude

read_documentation

Claude

run_saved_query

Claude

run_sql

Claude

select_database

Claude

update_saved_query

Claude

whoami

Claude

App Stats

15

Tools

Claude

Platforms

Works with

Claude

Data refreshed daily