Welcome!

Hello to sqStorage, the simple web-based open source inventory management system.

sqStorage is suitable for simple inventory management and inventory administration, but thanks to its easily expandable data structure, it can also be effectively used for archives, collections, or inventories of all kind.

It is particularly characterized by its simple user interface, but also offers additional features such as a REST API, an optional user system with access control, "custom fields" for using data fields for your specific requirements, or a CSV data export for further use in third-party applications.

sqStorage is currently translated into German (native), English, and Polish.

sqStorage can be self-managed and hosted, using:

  • PHP version 8.2 and upwards
  • PHP extensions: mysqli, gettext, intl, gd
  • using either MariaDB or SQLite
  • a websever like nginx, Apache or lighttpd
  • or as Docker-Container

Background

sqStorage is a free and open-source database-driven inventory and storage system.

sqStorage was originally written for a member of the Internet Forum ngb.to and expanded and improved with the help of other contributors. Later, the idea of offering an optional hosting package for sqStorage was born.

The actual development is carried out on and via the developer portal Github, and the sqStorage source code is open source, meaning it is freely accessible and viewable. The project is based on the "GNU General Public License v3.0".

The project website, the "repository," can be found publicly at:
https://github.com/jrie/sqstorage

Live demo

You can get started easily with sample data in sqStorage in the interactive sqStorage test environment, which is available online.

Please note that the demo resets every 24 hours at 3:00 AM (GMT+2).


Required access data

Demo URL ⟹https://demo.sqstorage.net

Log in as regular user.
You can add, edit, view, and remove content.

Username ⟹ user

Password ⟹ User2022

Log in as guest user.
You can view content but not add, change, or delete anything.

Username ⟹ guest

Password ⟹ GUESTtEST1

Feedback?

If you notice an error or a functionality is missing, please feel free to contact us.

E-Mail Jan for Demo Feedback | Feedback at Github

Current features

» Place items with basic informations, for example, the title, amount, comment, serial or other article number, and even images.

» Organization of items through custom storage and place names.

» Organization of items using categories and subcategories.

» Quick overview of storages or invetories of any kind.

» Sort storage area items by category, subcategory, name, amount, comment, or date.

» Custom datafields by optional category with predefined data types (number, text, and possible multi- or single-selections).

» Display the amount of items and positions for each storage area and categories.

» A optional user system with password protected logins and roles (admin, user, or guest) can be added on-demand or completely be disabled.

» Interactive search, even including custom data fields.

» "Quick edit"-mode which allows to quickly edit items from the inventory page.

» Collapse storages areas to be able to focus on particular storages.

» Optional pretty URLs, for example: „index.php“ turns to „index“.

» A usersetting for the start page to make usage a breeth

» A CSS print layout for the inventory and the categories #73

» CSV data export of cateogires, subcategories and inventories #74

» Creation of QR Codes for easier tagging and tracking inventory items

» QR Code options to check in and check out items

» QR Codes to quickly open a storage

⇑