slack-mcp-server-by-cdata
@CDataSoftware
This read-only MCP Server allows you to connect to Slack data from Claude Desktop through CData JDBC Drivers. Free (beta) read/write servers available at
Overview
What is slack-mcp-server-by-cdata?
slack-mcp-server-by-cdata is a read-only MCP server that allows LLMs (e.g., Claude Desktop) to query live Slack data using natural language. It wraps the CData JDBC Driver for Slack, which exposes Slack data as relational SQL models, so no SQL is required from the user.
How to use slack-mcp-server-by-cdata?
Clone the repository, build with mvn clean install, install and license the CData JDBC Driver for Slack, create a .prp file with connection details, then configure Claude Desktop by editing claude_desktop_config.json to point to the server JAR and .prp file. Restart Claude Desktop to activate. The server runs via stdio on the same machine as the client.
Key features of slack-mcp-server-by-cdata
- Read-only access to Slack data via MCP.
- Uses CData JDBC Driver for relational SQL models.
- Supports natural language queries through LLMs.
- Provides tools: get_tables, get_columns, run_query.
- Java‑based, built with Maven, runs on all major OS.
Use cases of slack-mcp-server-by-cdata
- Ask Claude Desktop about Slack messages or channels.
- Get a summary of recent activity in a Slack workspace.
- Generate reports on team communication patterns.
- Retrieve Slack data without writing SQL or API code.
FAQ from slack-mcp-server-by-cdata
Is this server read‑only?
Yes. The project builds a read-only MCP server. For full read, write, update, delete, and action capabilities, CData offers a separate paid beta server.
How do I authenticate to Slack?
If Slack uses OAuth, you must authenticate via your browser when generating the JDBC connection string using the Connection String utility. The string includes InitiateOAuth=GETANDREFRESH.
What transport does the server use?
The server communicates over stdio, so it can only be used with clients running on the same machine.
How do I troubleshoot connection issues?
Use the Connection String utility to test and copy the JDBC connection string into the .prp file. Ensure the driver JAR path and license are correct. If problems persist, contact CData support or join the CData community.
What tools does the server expose?
Three tools: {servername}_get_tables (list tables), {servername}_get_columns (list columns of a table), and {servername}_run_query (execute SQL SELECT). Their output is CSV.
