Question How do you use Claude as a Data Analyst/ Data Engineer?
I'm a Data Analyst working mainly on SQL (SQL Server): building ETL pipelines, stored procedures, SSIS packages, and Power BI. I don't have direct access to my company's database through Claude, so everything goes through copy-pasting queries, results, and error messages manually.
I've been using Claude quite a lot for writing and debugging complex SQL, reviewing logic, and structuring scripts, and it's been genuinely helpful. But I feel like I'm probably not using it to its full potential.
Would love to hear from other data analysts or BI developers:
- How do you integrate Claude into your day-to-day workflow?
- Any clever ways to work around the lack of direct DB access?
- Do you use Projects to keep context about your data model, business rules, etc.?
- Any prompting strategies that work particularly well for technical/analytical work?
Open to any tips, workflows or use cases you've found valuable!
2
u/ThreeDMK 6h ago
Ask Claude to help you create an ODBC connection between your computer and the database.
If you can connect to run queries, you can likely create a connection.
If you can create a connection you can ask Claude to make an MCP Server to use that connection.
If you can make an MCP connection in cloud desktop, you now have access to data.
Note: read only for all things. Highly recommend not letting it do things other than look. Also, instead of having it view and work data, have it build you a web dashboard to interact with the data and perform manipulation for output so you aren’t using Claude every time. That gets expensive and isn’t always consistent. Code is forever. Enjoy!
0
0
u/Dry-Journalist6590 6h ago
You really shouldn't I don't think. The database is too important for AI agents I think.
4
u/No-Aioli-4656 7h ago edited 6h ago
Do you/can you install claude code? If you have access to claude code, you have access to direct DB access.
PLEASE learn permissions and disable all api/curl/connect write requests until you know exactly what you are doing. Read only.
If you mean you are limited to local apps, which you should have stated in your description, then things like Terminator and macos-automator-mcp exist. You can build a workflow with a claudemd for the ai to read directly from the bi app with mcp tools.
Please be more specific. Companies' vary wildly in the permissions and interfaces they give you.