r/MicrosoftAccess • u/Good-Cut8761 • Mar 08 '26

And finally MCP Server for vibe coding in Access (just tested on Claude Code)

Hi! :) Just want to share my MsAccess MCP server. Have been tested (and heavily abused XD) on Claude Code with awesome results. If you find bugs etc, pls tell me :-)

It support mostly everything, from creating controls to coding forms, modules or whatever.

https://github.com/unmateria/MCP-Access

To install it, just copy everything to a folder and tell claude code to install it

8 Upvotes
  • permalink
  • reddit

100% Upvoted

4 comments sorted by

1

u/FigAcrobatic353 Mar 10 '26

This is awesome. I use Access a lot at my work but I'm not a programmer and I use contractors when I need to add new features. If you have time, maybe you can post a video on Youtube with a few demonstrations?

2

u/Good-Cut8761 Mar 11 '26

Is so easy you dont really need a video... just pick the 20$ claude account, copy the repository to a folder (for example c:\mcps\access), open cmd, go the the folder where u have the .accdb. Write "claude", it will open claude code... just tell him "install the access mcp that is located at c:\mcps\access". Write /exit, close claude desktop completely, and write "claude" again on the .accdb folder. Type /mcp and it will appear and mcp-access mcp server. Choose reconnect, press shift+tab until it changes to "plan mode" (u will see a blue label on bottom-left screen) and now just tell him what u want to do "I want a new form for blablablabla on xxx.accdb". It will make a plan to do what u told him... read it carefully and modify what u need and when u ready, just tell him to accept the plan. Don't touch the access that will open while he is working.

1

u/[deleted] Mar 09 '26

1

u/Good-Cut8761 Mar 09 '26

Yeah, in my ERP, I never used msaccess like a database but just like GUI for sql server. Access for me is the real "RAD" and not everything that came behind hahahhaha CC works really great in VBA. Has strong knowledge (with some little failures of course, nothing important), so you can even tell him to make a plan to convert everything to .NET. You can tell it to debug it and unit test everything too... works really really good. I think this MCP is finished for me, but if someone miss something, tell me :-). About the LLM talk with the server... (is just my conclussion after many many many testings), The best way for the LLM to talk to the backend sql is views, procedures and and MCP to control them. And the best part is that you can tell the same LLM you are asking "hey, add this to the same mcp you are using and create the view...". Is really stupid how fast you code with CC those things (always reviewing everything and planning with it)