Tech Panda Labs

Released · Software

TechPanda Inventory – Electronics Component Inventory Software

Open-source electronics parts inventory for Windows, Android and self-hosted Linux. Track components, drawer locations, stock movements, project parts, QR labels and optional voice lookup.

  • StatusReleased
  • Version1.1.0
  • PlatformsWindows, Android, Linux server, Web (self-hosted)
  • LicenseMIT
  • Updated
Editorial TechPanda Inventory cover with application dashboard screenshot, software title and device platform labels
On This Page

Overview

TechPanda Inventory is an open-source electronics component inventory application for keeping track of parts, quantities, locations, and the components used in DIY projects. It is intended for electronics workbenches where boards, modules, sensors, connectors, and passive components are stored across multiple drawers or boxes.

The application brings a searchable component catalog, stock movement records, project component lists, and workshop storage locations into one interface. You can run the published Windows or Android app locally, or choose a Linux-hosted installation when several devices need to use one shared inventory.

Illustrative workflow from cataloging electronic components to labeling drawer locations and tracking project stock
Illustrative inventory process: catalog parts, link locations and QR labels, then track usage in projects.

Core features and everyday workflows

Catalog components and their specifications

Create your own component types and add item records with a part name, manufacturer, unit of measurement, opening quantity, storage location, notes, and a component image. For example, a development board can be classified as a microcontroller, assigned to its drawer, and searched by name later.

The expanded component editor also supports optional supplier, price, expiry date, datasheet attachment, and pasted technical specifications fields. These can be hidden in Settings when they are not useful for a particular workshop.

TechPanda Inventory Components screen showing search, filters, add-component form and component image cards
Component catalog view with filters, editable details and images of stored electronic parts.

Record incoming and outgoing stock

Instead of replacing a quantity without a record, use stock-in, stock-out, returns, and loss adjustments. The stock history can be filtered by component, with pagination to make larger transaction lists easier to review.

The dashboard summarizes component types, distinct products, total stock quantities, and out-of-stock parts. Minimum stock levels make it easier to identify items that may need reordering.

TechPanda Inventory dashboard displaying component type counts, total products, stock quantity, inventory value and out-of-stock items
Dashboard metrics and stock totals help locate categories and parts that need attention.

Add locations corresponding to physical drawers, bins, shelves, or boxes. The rebuilt interface can generate a QR code for each location and print a sheet of storage labels. Scanning a label opens the inventory view for the corresponding location, provided the device can reach the relevant application.

Manage DIY projects and component requirements

Create project records, associate the components needed for a build, and record quantities consumed from inventory. The project workflow supports reducing available stock as parts are used, while PDF exports provide a component list to keep alongside a project.

Monitor value, expiry and replenishment

When prices have been entered, the app can calculate estimated inventory value. Optional expiry-date tracking and out-of-stock indicators identify records that need attention. The rebuilt project demonstration also presents reorder and purchase-order workflows.

Export records and protect your data

The application includes CSV/PDF reporting and backup/restore controls. The repository documents a local SQLite database, a media folder for uploaded images or documents, and backup archives containing database and media. Keep backups in a location separate from the device running the application.

TechPanda Inventory Settings screen listing optional supplier, pricing, expiry, datasheet and backup controls
Settings can show optional component fields and provides backup and server connection controls.

Who this software is for

Typical uses include locating spare ESP32 boards, keeping track of resistors and sensors stored in multiple drawers, recording parts taken for a prototype, and exporting a project component list. A single-device workshop may prefer the offline app; a shared bench with multiple PCs or phones may prefer a self-hosted server.

Platforms and requirements

FeatureLocal Windows or Android appSelf-hosted Linux server
Primary purposeInventory on the deviceOne shared database for multiple devices
InstallationPublished Windows or Android release assetDeploy the API and Flutter web interface to a Linux host
ConnectivityWorks without an always-on network connectionClients must reach the host on the LAN or through configured remote access
AdministrationManage device storage and backupsMaintain Linux, containers, credentials, database and backups
Browser useNot required for typical local app useFlutter Web interface served by the host

The repository documents Flutter for Android, Web/PWA and Windows; a FastAPI backend; SQLAlchemy/Alembic; SQLite by default; and optional PostgreSQL configuration for server use. The self-hosted deployment instructions target Ubuntu or Debian and use Docker Compose. Python 3.12 or newer and Paramiko are specified for the Windows remote-deployment helper.

How the application works

In local use, component data and associated media are held by the local installation. In self-hosted use, Windows, Android, and web clients send inventory requests to a FastAPI service running on a Linux machine. That service manages the inventory database and uploaded media, so connected clients can access the same records.

The standard deployment uses SQLite and documents PostgreSQL as an optional database for concurrent production use. Remote access through Cloudflare Tunnel is optional; the app can also be accessed over a local network. The operator remains responsible for access controls, credentials, updates and backups.

Download TechPanda Inventory

Open the GitHub Releases page and choose the Windows or Android download that matches your device. The current release shown on GitHub is v1.1.0. Linux hosting uses the repository source and deployment tools rather than the Android APK or Windows release package.

  1. Open the official Releases page

    Choose the latest suitable published release in the TechPanda Inventory GitHub repository.

  2. Install the appropriate build

    Use the Windows release package for a Windows PC or install the Android APK on an Android device according to your device settings.

  3. Open the app and secure the administrator account

    Complete any initial sign-in or setup and change default credentials before storing real data or enabling network access.

  4. Start with locations and components

    Create component types and drawer locations, then add your first part records and quantities.

Download published Windows and Android builds

Deploy on your own Linux server

A self-hosted installation is intended for people who want one shared inventory on a server they control. The repository includes a direct Linux deploy.sh script and a Windows remote-deployment helper. Confirm the repository deployment notes before running installer scripts on a production host.

Option A: deploy remotely from Windows

  1. Prepare the Linux host

    Use a reachable Ubuntu/Debian machine with SSH access, sufficient persistent storage and administrative permissions.

  2. Prepare the Windows machine

    Install Git and Python 3.12 or newer. Clone the official repository and install Paramiko for the deployment helper.

  3. Run the interactive helper

    Launch deploy_to_linux.bat or run deploy_remote.py from the repository root.

  4. Enter deployment settings

    Supply the host address, SSH account details, initial application administrator password, and optionally a Cloudflare Tunnel token. Do not include secrets in saved commands.

  5. Confirm the deployment

    Open the address and port reported by the installer, sign in, and verify that the inventory loads before linking another device.

git clone https://github.com/arslansadiq87/techpanda-inventory.git
cd techpanda-inventory
py -3.12 -m pip install paramiko
py -3.12 deploy_remote.py

Option B: deploy directly on Linux

The repository also describes cloning the project directly on Ubuntu or Debian, making deploy.sh executable, and running the script. Review what the script installs and the environment file it creates before proceeding.

git clone https://github.com/arslansadiq87/techpanda-inventory.git
cd techpanda-inventory
chmod +x deploy.sh
./deploy.sh

Read the official repository setup documentation

First-run setup and workshop routine

  1. Create an inventory structure

    Define types such as microcontrollers, capacitors, ICs, or sensors and map physical shelves or drawers to named locations.

  2. Add the stock you already own

    Record part names, quantities, storage location, optional images and datasheets. Use the current count as the opening quantity.

  3. Record each inventory change

    Use stock movements for purchases, withdrawals, returns or losses so that quantities and transaction history remain consistent.

  4. Prepare a build

    Add the required parts to a project, track parts actually consumed, and export its component list when a printable record is needed.

  5. Review alerts and back up

    Check low or zero quantities, optional expiry dates, and regularly export a backup including both inventory records and media.

Backup, privacy and security

The repository documents local storage at local_data/inventory.sqlite3 with associated media and backup folders in local-only development. It also describes backup archives that include the database and media files. Verify a restore process before relying on one backup copy; exporting a report does not replace a full data backup.

An offline installation avoids the need to send ordinary inventory requests to a remote server. Self-hosting lets you choose the server and network path, but does not by itself guarantee confidentiality or security. Use unique administrator credentials, keep server secrets outside Git, install software updates, restrict who can access the app and use HTTPS for remote clients.

Cloudflare Tunnel can provide an HTTPS route to the server without directly exposing its application port, but its use introduces an external network service and requires appropriate access policy. ESP32 voice functionality is a separate integration that also depends on the configured speech-processing components.

Read the repository security policy

ESP32 voice inventory integration (optional)

The second Tech Panda video demonstrates a voice-controlled inventory lookup using an ESP32-S3 and Seeed Studio ReSpeaker XVF3800 microphone array. A custom wake word, “Hi Tech Panda,” activates a workflow that can ask about stock quantity or a storage location and return a spoken response.

This is not a built-in voice feature of the standard Windows or Android installer. The demo combines the ReSpeaker audio front end, ESP32-S3 wake-word handling, speech recognition, access to the inventory server, and text-to-speech. The repository contains separate ESP32 voice-assistant and wake-word folders for further reference.

Troubleshooting and limitations

The app cannot connect to my Linux server

Confirm the server address and port, verify that the deployment completed, and open the web interface from a browser on the same network. Then use the Server Connection test in the app. For remote access, confirm that the tunnel and access settings match the deployed service.

I cannot find a part in a scanned drawer

Confirm that the part has the intended storage location assigned and that the QR label belongs to that same location. The scanning device must be able to open the relevant local or hosted inventory view.

My offline devices show different quantities

Separate offline installations do not automatically share one database. Configure the shared Linux server when you need the same inventory across several devices, and review the migration or sync workflow before switching an existing installation.

A feature from the video is missing

Compare the installed release against the latest repository documentation and settings. Optional supplier, pricing, expiry and datasheet fields can be hidden; some features shown in a later demonstration may differ from a published binary release.

Known operational constraints

Self-hosting requires maintenance of the Linux machine, network access, storage and backups. Optional features such as pricing depend on users entering the necessary data. The ESP32 voice demonstration needs additional hardware and supporting services. No independent performance, accessibility or security audit is claimed here.

Video demonstrations

This video covers the expanded component fields, stock and expiry alerts, QR-coded drawers, Windows/Android releases, the automated Linux deployment process, and the separate ESP32-S3/ReSpeaker voice-search demonstration.

Original electronics component inventory walkthrough

The first video follows the initial workflow: creating types and locations, adding components, stock movement history, organizing project parts, reporting, and installing the offline application.

Source code, downloads and license

TechPanda Inventory is maintained as a public GitHub project and distributed under the MIT license stated in its LICENSE file. Review third-party notices and the repository instructions when building or redistributing the software. For bugs and enhancement proposals, use the public issue tracker; use the security policy rather than public issues to report vulnerabilities.

GitHub source repository

Published releases

Documentation and deployment guide

Report a bug or request a feature

Frequently asked questions

Does it require a cloud account?

A local Windows or Android installation can be used offline without a hosted inventory service. A Linux deployment is optional when you need shared, network-accessible records.

Can I print a bill of materials for a project?

The original walkthrough demonstrates exporting a project component list as a PDF.

Can several phones and computers access the same stock?

Yes, when the clients connect to a common self-hosted Linux inventory server. Separate standalone offline installations are not automatically synchronized.

Do I need an ESP32 or microphone to use the app?

No. ESP32-S3 and ReSpeaker XVF3800 hardware are used for the optional voice assistant demonstration, not for standard component inventory management.