Microsoft Access Database
JSON →Allows AI to interact with Microsoft Access databases, supporting data import and export via CSV files.
Tools · 11
- list List all active databases available in the server.
- create Create a new database file (for Microsoft Access, copies the empty.mdb template).
- connect Connect to an existing database file, or creates an in-memory database if the file is not specified.
- disconnect Close a database connection. For in-memory databases, this will clear all its data.
- query Execute a SQL query to retrieve data from a database.
- update Execute a SQL query to insert/update/delete data in a database.
- import_csv Imports data from a CSV file into a database table.
- export_csv Exports data from a database table to a CSV file.
- import_excel Imports data from an Excel file into a database table.
- read_notes Reads notes from the specified file, or discovers notes in the specified directory.
- write_notes Writes notes to the specified file, or linked to the specified database.
Links
★ 8 GitHub stars