# 使用 Homebrew, apk, apt, dnf, MacPorts, Nix, zypper 安装 mdbtools 查看 mdbtools 的安装路径、可执行文件、元数据以及面向 AI 代理工作流的安全说明。 ## 安装 ```sh sudo av install brew:mdbtools ``` 其他安装命令: ### macOS - Homebrew (100%): ```sh brew install mdbtools ``` 证据: local Homebrew formula metadata - MacPorts (94%): ```sh sudo port install mdbtools ``` 证据: MacPorts ports tree: databases/mdbtools/Portfile from https://api.github.com/repos/macports/macports-ports/git/trees/master?recursive=1 ### Linux - apk (92%): ```sh sudo apk add mdbtools ``` 证据: Alpine Linux edge package indexes: mdbtools from https://dl-cdn.alpinelinux.org/alpine/edge/community/x86_64/APKINDEX.tar.gz - Debian apt (92%): ```sh sudo apt install mdbtools ``` 证据: Debian stable package indexes: mdbtools from https://deb.debian.org/debian/dists/stable/main/binary-amd64/Packages.xz - dnf (92%): ```sh sudo dnf install mdbtools ``` 证据: Fedora Rawhide package metadata: mdbtools from https://dl.fedoraproject.org/pub/fedora/linux/development/rawhide/Everything/x86_64/os/repodata/07190dc5ae9f35ae73866675fed6d95fe6e8d9fe22c9d7cdf85862cb2ed24a4c-primary.xml.zst - Nix (92%): ```sh nix profile install nixpkgs#mdbtools ``` 证据: nixpkgs package indexes: pkgs/by-name/md/mdbtools/package.nix from https://api.github.com/repos/NixOS/nixpkgs/git/trees/master?recursive=1 - zypper (92%): ```sh sudo zypper install mdbtools ``` 证据: openSUSE Tumbleweed package metadata: mdbtools from https://download.opensuse.org/tumbleweed/repo/oss/repodata/50b07339cb64c8ed4091bdbabddadc1ff5737b090e478818a195b40d8a3292861a879139b4a3987c31109699fde9fbf4a716367ddf4eef77da75f96e3193d6ed-primary.xml.zst ## 软件包事实 - **软件包键:** brew:mdbtools - **软件包管理器:** Homebrew - **版本:** 1.0.1 - **来源摘要:** Tools to facilitate the use of Microsoft Access databases - **主页:** - **仓库:** - **最后更新:** 2026-06-22T14:05:27-07:00 - **已生成:** 2026-08-03T19:37:03+00:00 ## 可执行文件 - mdb-array (别名) - mdb-count (别名) - mdb-export (别名) - mdb-header (别名) - mdb-hexdump (别名) - mdb-json (别名) - mdb-parsecsv (别名) - mdb-prop (别名) - mdb-queries (别名) - mdb-schema (别名) - mdb-sql (别名) - mdb-tables (别名) - mdb-ver (别名) ## 安装行为 - Bottle: 不可用 ## 版本和新鲜度 - 页面生成时间: 2026-08-03 - 管理器版本: 1.0.1 ## 项目历史与用法 MDB Tools is a suite for reading and extracting data from Microsoft Access MDB databases on Unix-like systems. The upstream README describes command-line utilities, core libraries, a SQL engine, and an ODBC driver. ### 项目历史 The official GitHub repository was created on 2010-06-16, but the NEWS file preserves older project history through releases such as 0.3 and 0.7.1. The project centers on reverse-engineering the Jet3 and Jet4 MDB file formats, documented in the upstream HACKING file. MDB Tools 0.9.0 marked a major restart. The NEWS file says the project was under new management, moved its canonical home to GitHub, collected years of unapplied patches, made GLib optional, added in-memory opening, improved thread safety, added `mdb-count` and `mdb-queries`, and moved the former GNOME GUI into the separate `gmdb2` project. Later 0.9.x releases emphasized security, fuzzing, Access-version support, ODBC fixes, SQL improvements, and documentation updates. Version 1.0.0 stabilized the generated `mdbtools.h` approach and kept API and ABI compatibility with the 0.9 series for most users. ### 采用历史 The supplied package-manager metadata shows MDB Tools shipped by Homebrew, Alpine, Debian/Ubuntu, Fedora, MacPorts, Nix, and openSUSE. Its adoption is tied to a persistent niche: extracting tables, schemas, and queries from Microsoft Access files on systems where Access itself is unavailable. The README also documents installation through Debian, Homebrew, and MacPorts, confirming that upstream expects users to obtain the suite from package managers as well as from source. ### 使用方式 The utility suite includes commands such as `mdb-tables` to list tables, `mdb-schema` to print DDL, `mdb-export` to export tables to CSV or SQL, `mdb-json` to emit JSON, `mdb-count` for row counts, `mdb-sql` for simple SQL, and `mdb-queries` for saved Access queries. Library and integration users can use `libmdb`, `libmdbsql`, and the ODBC driver. The README describes ODBC support for unixODBC or iODBC and notes that man pages provide usage instructions for each program. ### 为什么软件包爱好者会关心 MDB Tools is package-manager significant because it turns a proprietary desktop database format into Unix command-line data plumbing. It lets shell scripts, ETL jobs, distro packages, and server environments inspect Access databases without Microsoft Access. It is also a long-lived reverse-engineering project: the HACKING documentation records byte-level Jet file-format knowledge, while the NEWS file shows continuing maintenance against malformed inputs, newer Access formats, build systems, and ODBC behavior. ### 时间线 - 2010-06-16: Official GitHub repository created. - 0.7.1: NEWS records modernization of autoconf/automake bootstrapping and experimental Unicode ODBC support. - 0.9.0: Project moved to its new GitHub home under new management and absorbed years of patches. - 0.9.2: Security and bug-fix release prompted by OSS-Fuzz memory-error findings. - 1.0.0: Generated `mdbtools.h` and API/ABI compatibility notes for 0.9-series users. ### Related projects - The README says the GNOME MDB viewer/debugger moved to https://github.com/mdbtools/gmdb2. - MDB Tools integrates with unixODBC or iODBC for ODBC access to MDB files. ### 来源 - - - - - source_facts.package-manager ## 安全说明 broad file, network, media, or database tool signal. - **Geiger 风险:** blue / 中 - broad file, network, media, or database tool signal ## 其他软件包管理器记录 - Debian apt - libmdb3t64 - 1.0.1-0.1: normalized package name match | Debian stable package indexes: libmdb3t64 from https://deb.debian.org/debian/dists/stable/main/binary-amd64/Packages.xz | Core library for accessing JET / MS Access (MDB) files | https://github.com/mdbtools/mdbtools - Debian apt - libmdbsql3t64 - 1.0.1-0.1: normalized package name match | Debian stable package indexes: libmdbsql3t64 from https://deb.debian.org/debian/dists/stable/main/binary-amd64/Packages.xz | mdbtools SQL library | https://github.com/mdbtools/mdbtools - Debian apt - mdbtools - 1.0.1-0.1: normalized package name match | Debian stable package indexes: mdbtools from https://deb.debian.org/debian/dists/stable/main/binary-amd64/Packages.xz | JET / MS Access database (MDB) tools | https://github.com/mdbtools/mdbtools - Debian apt - mdbtools-dev - 1.0.1-0.1: normalized package name match | Debian stable package indexes: mdbtools-dev from https://deb.debian.org/debian/dists/stable/main/binary-amd64/Packages.xz | mdbtools development files | https://github.com/mdbtools/mdbtools - Debian apt - mdbtools-doc - 1.0.1-0.1: normalized package name match | Debian stable package indexes: mdbtools-doc from https://deb.debian.org/debian/dists/stable/main/binary-amd64/Packages.xz | Dummy package | https://github.com/mdbtools/mdbtools - Debian apt - odbc-mdbtools - 1.0.1-0.1: normalized package name match | Debian stable package indexes: odbc-mdbtools from https://deb.debian.org/debian/dists/stable/main/binary-amd64/Packages.xz | MDB tools ODBC driver | https://github.com/mdbtools/mdbtools - Nix - mdbtools: normalized package name match | nixpkgs package indexes: pkgs/by-name/md/mdbtools/package.nix from https://api.github.com/repos/NixOS/nixpkgs/git/trees/master?recursive=1 - Ubuntu apt - libmdb3t64 - 1.0.0+dfsg-1.2ubuntu1: normalized package name match | Ubuntu 24.04 LTS package indexes: libmdb3t64 from https://archive.ubuntu.com/ubuntu/dists/noble/universe/binary-amd64/Packages.gz | Core library for accessing JET / MS Access (MDB) files | https://github.com/mdbtools/mdbtools - Ubuntu apt - libmdbsql3t64 - 1.0.0+dfsg-1.2ubuntu1: normalized package name match | Ubuntu 24.04 LTS package indexes: libmdbsql3t64 from https://archive.ubuntu.com/ubuntu/dists/noble/universe/binary-amd64/Packages.gz | mdbtools SQL library | https://github.com/mdbtools/mdbtools - Ubuntu apt - mdbtools - 1.0.0+dfsg-1.2ubuntu1: normalized package name match | Ubuntu 24.04 LTS package indexes: mdbtools from https://archive.ubuntu.com/ubuntu/dists/noble/universe/binary-amd64/Packages.gz | JET / MS Access database (MDB) tools | https://github.com/mdbtools/mdbtools - Ubuntu apt - mdbtools-dev - 1.0.0+dfsg-1.2ubuntu1: normalized package name match | Ubuntu 24.04 LTS package indexes: mdbtools-dev from https://archive.ubuntu.com/ubuntu/dists/noble/universe/binary-amd64/Packages.gz | mdbtools development files | https://github.com/mdbtools/mdbtools - Ubuntu apt - mdbtools-doc - 1.0.0+dfsg-1.2ubuntu1: normalized package name match | Ubuntu 24.04 LTS package indexes: mdbtools-doc from https://archive.ubuntu.com/ubuntu/dists/noble/universe/binary-amd64/Packages.gz | Dummy package | https://github.com/mdbtools/mdbtools - Ubuntu apt - odbc-mdbtools - 1.0.0+dfsg-1.2ubuntu1: normalized package name match | Ubuntu 24.04 LTS package indexes: odbc-mdbtools from https://archive.ubuntu.com/ubuntu/dists/noble/universe/binary-amd64/Packages.gz | MDB tools ODBC driver | https://github.com/mdbtools/mdbtools - apk - mdbtools - 1.0.1-r2: normalized package name match | Alpine Linux edge package indexes: mdbtools from https://dl-cdn.alpinelinux.org/alpine/edge/community/x86_64/APKINDEX.tar.gz | library for reading MS Access database files | https://github.com/mdbtools/mdbtools - apk - mdbtools-bash-completion - 1.0.1-r2: normalized package name match | Alpine Linux edge package indexes: mdbtools-bash-completion from https://dl-cdn.alpinelinux.org/alpine/edge/community/x86_64/APKINDEX.tar.gz | Bash completions for mdbtools | https://github.com/mdbtools/mdbtools - apk - mdbtools-dev - 1.0.1-r2: normalized package name match | Alpine Linux edge package indexes: mdbtools-dev from https://dl-cdn.alpinelinux.org/alpine/edge/community/x86_64/APKINDEX.tar.gz | library for reading MS Access database files (development files) | https://github.com/mdbtools/mdbtools ## Combined YAML source View the package source record on GitHub. [combined/mdbtools.yml](https://github.com/mxcl/pkgdb/blob/main/combined/mdbtools.yml) ## 来源 - pkg.so package database - Geiger risk classifier - curated package history - pkgdb category and tag curation - external package-manager database matches - cross-ecosystem install command graph