taxjar_get_tablesLABSCO SUMMARY
SQL access to TaxJar for people who will never write SQL.
Once the driver is licensed and the connection string is in place, the assistant can answer questions about live TaxJar records without anyone touching a query editor. The setup, not the usage, is the work: you install a JDBC driver, license it through its own utility, test the connection string, and hand-write a properties file. Writes are out of scope here — CData sells a separate MCP server for read, write, update, delete and actions.
What it is
A Java MCP server that wraps the CData JDBC Driver for TaxJar and exposes TaxJar as relational SQL tables, so a client can retrieve live data from natural-language questions. This build is read-only: queries are SELECT only.
What you get
- A tool that lists the tables the driver exposes, returned as CSV with a header row
- A tool that lists the columns on any one of those tables
- A tool that runs a SQL SELECT and hands back the rows
- Tool names carry the prefix you set in the .prp file — the sample
Prefix=taxjargivestaxjar_get_tables,taxjar_get_columnsandtaxjar_run_query - Calls you can script without a chat client: the repository README has a JSON-RPC 2.0 request example for each tool
Requirements
Build the jar with mvn clean install, then install and license the CData JDBC Driver for TaxJar (java -jar cdata.jdbc.taxjar.jar --license takes your name, email, and TRIAL or a licence key). Write a .prp file holding Prefix, ServerName, DriverPath, DriverClass and the JdbcUrl you copy out of the driver's connection-string utility. The server speaks stdio, so it only works with clients on the same machine.
Setup effort
Build from source — clone the repository, then point your client at the binary
USE CASES
01
Finding out what data is even there
Ask for the table list, then the columns on the one that looks right, before writing any question that depends on a field name.
02
Answering a reporting question without SQL
Ask the question in English and let the server turn it into a SELECT against the TaxJar tables.
03
Scripting the calls instead of chatting
Send JSON-RPC 2.0 payloads straight at the server, passing your SQL in the run-query arguments.
3 tools
Listed in project docs. Your client may show a different list.
taxjar_get_columnstaxjar_run_queryBEFORE YOU INSTALL
What to know first
Tools you get
3 tools named in the project's documentation. All three only read: run_query executes SELECT, so nothing here files or calculates tax; full read-write access is CData's separate paid MCP Server for TaxJar. Tool names start with the Prefix in the .prp file (taxjar_ in the sample).
Where it runs
The documented client runs the server on your machine.
INSTALLATION
Connect your client
Clone the repository, then point your client at the binary. This one is built from source rather than installed with a single command.
Server setup
TERMINAL
git clone https://github.com/cdatasoftware/taxjar-mcp-server-by-cdata.git
cd taxjar-mcp-server-by-cdata
mvn clean installDownload and install the CData JDBC Driver for TaxJar from https://www.cdata.com/drivers/taxjar/download/jdbc
License the driver: in the driver's lib folder run java -jar cdata.jdbc.taxjar.jar --license and enter your name, email, and "TRIAL" (or your license key)
Run java -jar cdata.jdbc.taxjar.jar to open the Connection String utility, configure and test the connection, then copy the connection string
Create taxjar.prp with:
FILE · taxjar.prp
Prefix=taxjar
ServerName=CDataTaxJar
ServerVersion=1.0
DriverPath=<YOUR_DRIVER_PATH>
DriverClass=cdata.jdbc.taxjar.TaxJarDriver
JdbcUrl=<YOUR_JDBC_URL>
Tables=Tables only picks which tables also get a ready-made description for your assistant, and empty means none; the server can still list and query every table your connection string reaches, so to keep data out of reach, limit that connection or the account it signs in with.
Add the mcpServers entry below to claude_desktop_config.json and restart the client
(optional, to run standalone) java -jar <YOUR_PATH_TO_CDATA_MCP_JAR_WITH> <YOUR_PATH_TO_TAXJAR>
MCP Clients
Claude Desktop — macOS, Linux
CLAUDE DESKTOP — MACOS, LINUX · JSON
{
"mcpServers": {
"taxjar": {
"command": "<YOUR_PATH_TO_JAVA>",
"args": [
"-jar",
"<YOUR_PATH_TO_CDATA_MCP_JAR_WITH>",
"<YOUR_PATH_TO_TAXJAR>"
]
}
}
}