Part-DB is an Open-Source inventory management system for your electronic components. It is installed on a web server and so can be accessed with any browser without the need to install additional software.
The version in this repository is a complete rewrite of the legacy Part-DB (Version < 1.0) based on a modern framework and is the recommended version to use.
If you find a bug, please open an Issue on GitHub, so it can be fixed for everybody.
You can log in with username: user and password: user.
Every change to the master branch gets automatically deployed, so it represents the current development progress and is maybe not completely stable. Please mind, that the free Heroku instance is used, so it can take some time when loading the page for the first time.
- Inventory management of your electronic parts. Each part can be assigned to a category, footprint, manufacturer and multiple store locations and price information. Parts can be grouped using tags. You can associate various files like datasheets or pictures with the parts.
- Multi-Language support (currently German, English, Russian, Japanese, French, Czech, Danish and Chinese)
- Barcodes/Labels generator for parts and storage locations, scan barcodes via webcam using the builtin barcode scanner
- User system with groups and detailed (fine granular) permissions. Two-factor authentication is supported (Google Authenticator and Webauthn/U2F keys) and can be enforced for groups. Password reset via email can be setup.
- Optional support for single sign-on (SSO) via SAML (using an intermediate service like Keycloak you can connect Part-DB to an existing LDAP or Active Directory server)
- Import/Export system for parts and datastructure. BOM import for projects from KiCAD is supported.
- Project management: Create projects and assign parts to the bill of material (BOM), to show how often you could build this project and directly withdraw all components needed from DB
- Event log: Track what changes happens to your inventory, track which user does what. Revert your parts to older versions.
- Responsive design: You can use Part-DB on your PC, your tablet and your smartphone using the same interface.
- MySQL and SQLite supported as database backends
- Support for rich text descriptions and comments in parts
- Support for multiple currencies and automatic update of exchange rates supported
- Powerful search and filter function, including parametric search (search for parts according to some specifications)
- Automatic thumbnail generation for pictures
- Use cloud providers (like Octopart, Digikey, farnell or TME) to automatically get part information, datasheets and prices for parts
- API to access Part-DB from other applications/scripts
- Integration with KiCad: Use Part-DB as central datasource for your KiCad and see available parts from Part-DB directly inside KiCad.
With these features Part-DB is useful to hobbyists, who want to keep track of their private electronic parts inventory, or makerspaces, where many users have should have (controlled) access to the shared inventory.
Part-DB is also used by small companies and universities for managing their inventory.
- A web server (like Apache2 or nginx) that is capable of running Symfony 5, this includes a minimum PHP version of PHP 8.1
- A MySQL (at least 5.7) /MariaDB (at least 10.2.2) database server if you do not want to use SQLite.
- Shell access to your server is highly suggested!
- For building the client side assets yarn and nodejs (>= 18.0) is needed.
If you want to upgrade your legacy (< 1.0.0) version of Part-DB to this version, please read this first.
Below you find some very rough outline of the installation process, see here for a detailed guide how to install Part-DB.
- Copy or clone this repository into a folder on your server.
- Configure your webserver to serve from the
public/folder. See here for additional information.
- Copy the global config file
cp .env .env.localand edit
- Change the line
- If you do not want to use SQLite, change the value of
DATABASE_URL=to your needs ( see here) for the format. In bigger instances with concurrent accesses, MySQL is more performant. This can not be changed easily later, so choose wisely.
- Change the line
- Install composer dependencies and generate autoload files:
composer install -o --no-dev
- Install client side dependencies and build it:
- Optional (speeds up first load): Warmup cache:
php bin/console cache:warmup
- Upgrade database to new scheme (or create it, when it was empty):
php bin/console doctrine:migrations:migrateand follow the instructions given. During the process the password for the admin is user is shown. Copy it. Caution: This steps tamper with your database and could potentially destroy it. So make sure to make a backup of your database.
- You can configure Part-DB via
config/parameters.yaml. You should check if settings match your expectations, after you installed/upgraded Part-DB. Check if
partdb.default_currencymatches your mainly used currency (this can not be changed after creating price information). Run
php bin/console cache:clearwhen you changed something.
- Access Part-DB in your browser (under the URL you put it) and login with user admin. Password is the one outputted
during DB setup.
If you can not remember the password, set a new one with
php bin/console app:set-password admin. You can create new users with the admin user and start using Part-DB.
When you want to upgrade to a newer version, then just copy the new files into the folder and repeat the steps 4. to 7.
Normally a random password is generated when the admin user is created during initial database creation,
however you can set the initial admin password, by setting the
INITIAL_ADMIN_PW env var.
You can configure Part-DB to your needs by changing environment variables in the
See here for more information.
If you are using a reverse proxy, you have to ensure that the proxies sets the
X-Forwarded-* headers correctly, or you
will get HTTP/HTTPS mixup and wrong hostnames.
If the reverse proxy is on a different server (or it cannot access Part-DB via localhost) you have to set
TRUSTED_PROXIES env variable to match your reverse proxies IP-address (or IP block). You can do this in
.env.local or (when using docker) in your
Donate for development
If you want to donate to the Part-DB developer, see the sponsor button in the top bar (next to the repo name). There you will find various methods to support development on a monthly or a one time base.
- Symfony 5: The main framework used for the serverside PHP
- Bootstrap 5 and Bootswatch: Used as website theme
- Fontawesome: Used as icon set
- Jan Böhmer - Initial work - GitHub
See also the list of contributors who participated in this project.
Based on the original Part-DB by Christoph Lechner and K. Jacobs
Part-DB is licensed under the GNU Affero General Public License v3.0 (or at your opinion any later). This mostly means that you can use Part-DB for whatever you want (even use it commercially) as long as you publish the source code for every change you make under the AGPL, too.
See LICENSE for more information.