dropbox_get_tablesLABSCO SUMMARY
File metadata becomes something you can ask questions about.
Treating a Dropbox account as tables changes what you can ask: not just 'find this file' but 'what is in this folder tree, sorted by size and last modified'. Restricting the query tool to SELECT is what makes it safe to point at an account holding real work — the assistant can read but cannot move or delete. The price is a licensed JDBC driver, a Maven build and one browser authentication before the first question.
What it is
A local, read-only MCP server that exposes Dropbox as a relational SQL model. It wraps CData's JDBC driver for Dropbox, which presents the account's files, folders and metadata as tables, so an assistant can discover the schema and answer questions with live SELECT queries.
What you get
- The tables available in Dropbox, returned as CSV with a header row —
get_tables - The columns on a chosen table, so a query targets real column names —
get_columns - A SQL SELECT executed against live Dropbox data —
run_query - Tool names prefixed with the server name from your properties file, so several CData servers can coexist in one client
- A
Tablessetting that only picks which tables also get a ready-made description (blank means none); it does not limit what the tools can list or query, so limit the connection or the account it signs in with
Requirements
A Dropbox account, plus CData's JDBC driver for Dropbox downloaded and licensed separately — java -jar cdata.jdbc.dropbox.jar --license takes your name, email and TRIAL or a license key. Java and Maven: mvn clean install produces the runnable JAR. Then a .prp file with the prefix, server name and version, the driver JAR path, the driver class cdata.jdbc.dropbox.DropboxDriver, and the JDBC connection string from the driver's connection-string utility — since Dropbox uses OAuth, that utility opens a browser to authenticate. The client entry runs java with the JAR and the .prp path. Communication is over stdio, so client and server must be on the same machine. MIT licensed.
Setup effort
Build from source — clone the repository, then point your client at the binary
USE CASES
Asking about your files instead of browsing them
Let the assistant discover the schema and write a query over the account's file and folder metadata.
Working out what is taking up space
Query file metadata by size and location rather than clicking through folders.
Joining storage data to another system
Run this alongside another CData server in the same client, each with its own prefix.
3 tools
Listed in project docs. Your client may show a different list.
dropbox_get_columnsdropbox_run_queryBEFORE YOU INSTALL
What to know first
Tools you get
3 tools named in the project's documentation. Tool names take the server name from your config file, as {servername}_get_tables, {servername}_get_columns and {servername}_run_query. The server is read-only (SELECT only), and files appear as metadata rows, not contents.
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
git clone https://github.com/cdatasoftware/dropbox-mcp-server-by-cdata.git
cd dropbox-mcp-server-by-cdata
mvn clean installDownload and install the CData JDBC Driver for Dropbox from https://www.cdata.com/drivers/dropbox/download/jdbc
License the driver: in the driver's lib folder run java -jar cdata.jdbc.dropbox.jar --license, then enter name, email and "TRIAL" (or your license key)
Run java -jar cdata.jdbc.dropbox.jar to open the Connection String utility, test the connection and copy the connection string
Create a .prp file with Prefix / ServerName / ServerVersion / DriverPath / DriverClass=cdata.jdbc.dropbox.DropboxDriver / JdbcUrl / 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
MCP Clients
Claude Desktop — macOS/Linux
{
"mcpServers": {
"dropbox": {
"command": "<YOUR_PATH_TO_JAVA>",
"args": [
"-jar",
"<YOUR_PATH_TO_CDATA_MCP_JAR_WITH>",
"<YOUR_PATH_TO_DROPBOX>"
]
}
}
}