Data Science Stack
Query databases, analyze data, search research papers, and manage experiments from your AI coding environment.
Token Budget
This stack is lightweight. Plenty of room for your prompts and code context.
Config
Paste in ~/.claude.json
{
"mcpServers": {
"filesystem-mcp": {
"command": "npx",
"args": [
"-y",
"@modelcontextprotocol/server-filesystem",
"/path/to/allowed/directory"
]
},
"postgres-mcp": {
"command": "npx",
"args": [
"-y",
"@modelcontextprotocol/server-postgres",
"postgresql://localhost/mydb"
],
"env": {
"POSTGRES_CONNECTION_STRING": "YOUR_POSTGRES_CONNECTION_STRING"
}
},
"sqlite-mcp": {
"command": "npx",
"args": [
"-y",
"sqlite-mcp"
]
},
"exa-mcp": {
"command": "npx",
"args": [
"-y",
"exa-mcp-server"
],
"env": {
"EXA_API_KEY": "YOUR_EXA_API_KEY"
}
},
"sequential-thinking-mcp": {
"command": "npx",
"args": [
"-y",
"@modelcontextprotocol/server-sequential-thinking"
]
}
}
}Included Servers
PostgreSQL MCP
Anthropic
Query and interact with PostgreSQL databases, inspect schemas, and run SQL directly from your AI editor.
Query production databases directly from your AI assistant. Essential for exploratory data analysis without writing one-off scripts.
SQLite MCP
Community
Query and manage SQLite databases. Create tables, run queries, and inspect data directly from your AI editor.
Spin up lightweight local databases for experiments and intermediate results. Perfect for prototyping data pipelines before scaling to Postgres.
Filesystem MCP
Anthropic
Read, write, search, and manage files on your local filesystem with secure directory-scoped access for your AI editor.
Read CSVs, write outputs, and manage Jupyter notebooks. Data science lives and dies by file I/O.
Exa Search MCP
Exa
AI-powered web search and crawling with Exa. Get semantically relevant results, extract content, and find similar pages.
Find research papers, datasets, and methodology references with semantic search. Speeds up the literature review phase significantly.
Sequential Thinking MCP
Anthropic
Enable structured, step-by-step reasoning for complex problem solving. Helps AI break down problems into logical sequences.
Statistical analysis and pipeline design require step-by-step reasoning. Prevents your AI from skipping critical assumptions in complex analyses.
Recommended Skills
Skills that pair with the servers in this stack. Learn more
For PostgreSQL MCP
PostgreSQL optimization guide covering query performance, connection management, indexing strategies, and schema design.
npx skillsadd supabase/agent-skills/supabase-postgres-best-practicesPostgreSQL table design patterns including normalization, indexing, partitioning, and data type selection.
npx skillsadd wshobson/agents/postgresql-table-design