PowerShell port of unmateria/MCP-Access (4 Viewers)

[Doozer]

Hey folks - I created a port of unmateria's fantastic MCP-Access server. Just without the MCP server, since AI agents can use PowerShell via CLI to interact with Access databases via COM. I've attached .ps1 file and how to set it up in GitHub Copilot with a custom access-dev.agent.md. Hope this is allowed. If not, let me know, and I'll remove it.

This is the first version. It has total feature parity. I'm working on refactoring the .ps1 file into separate modules. I mainly did this because I didn't want to install and set up Python environments for every person at my job who wants to use AI for access development.

 

[Jason Lee Hayes]

Hey folks - I created a port of unmateria's fantastic MCP-Access server. Just without the MCP server, since AI agents can use PowerShell via CLI to interact with Access databases via COM. I've attached .ps1 file and how to set it up in GitHub Copilot with a custom access-dev.agent.md. Hope this is allowed. If not, let me know, and I'll remove it.

This is the first version. It has total feature parity. I'm working on refactoring the .ps1 file into separate modules. I mainly did this because I didn't want to install and set up Python environments for every person at my job who wants to use AI for access development.

Sweet..

 

[unmateria]

Love it! is MUCH more clear than the python mess!! hahahahha Yeah! a refactor is really necesary or you will end with a ton of tokens waste on each update! also is much better for documenting it. Great, great i like it!

 

[Doozer]

Love it! is MUCH more clear than the python mess!! hahahahha Yeah! a refactor is really necesary or you will end with a ton of tokens waste on each update! also is much better for documenting it. Great, great i like it!

The refactor is done. I’ll upload it tomorrow.

 

[unmateria]

if u upload to github or somewhere else, tell me and I will link it on my github readme too. The powershell aproach will be easier to use for people that just want to use skills. I also mantain the readme changelog with a resume, but if you prefer, I can tell CC to make a better explain of changes so you can get them with your CC and mantain it easier... just "check unmateria mcp-access changelog from 2 weeks to present and make a plan to implement what is not already implemented"... damn, CC has made me so lazy hahahahhahahahha

 

[Doozer]

I uploaded this version to this repo - jcolozzi/MSAccess-agent

I'm working on some corrections after taking the refactored modules for test run building an app. I'll update the repo and here once I'm finished.

 

[Doozer]

Let me know if there are any bugs.