Hello, everyone
About half year ago I have created a KiCAD database library for my hobby use and I want to share it. Maybe someone will find it useful and would like to create their own database or modify their own library.
Before it I just had an excel spreadsheet where I had stored information about the components I have and just used symbols and footprints from KiCAD, and add internal part number “#ID” to KiCAD component and used “lookup” excel function to fill all the other information when I extracted BoM from KiCAD. Although it was quite efficient because for most of the components I could just find symbols and footprints from KiCAD library, because I was using DB library at my work, I thought maybe I could make one for my hobby and use it instead of excel.
Excel Component Library:
Added component ID number from DBLib:
Extracted and Modified BoM:
Now I will tell you about my database library:
To create a database library I had created a dummy test library to test how it works. Then I created structure of my library.
For the structure I wanted to have several libraries in my database separated by the type of components for easier search. The libraries looks like this:
Then I needed to find out what columns I would be needed for the library. Most of the columns I have just transferred from my Excel component list and added a few. There is the list:
After that I created a database using SQLiteStudio (Instruction how to do this will be added to Github together with an example database library). My created database looks like this:
After that I had to setup my KiCAD for the database by adding new Environmental variables, setup symbol and footprint libraries and adding database to symbol libraries. I had added Visible marking in symbol libraries so that I only could use database library in project or Power Ports:
I have designed already 5 small projects with this library and I like how it turned out. There is what I have noticed using database library:
Database library pros:
• No need excel component sheet, everything is stored in database and visible directly in KiCAD
• If I find a mistake in a component information, I just need to fix it in database and update component from library in KiCAD
• Re-using component is very easy and fast
• Easy to search what component you have and can use for a project directly in KiCAD
• Attach symbols and footprint to several to several components are very easy, just copy-paste footprint or symbol name
• Easy to setup to use across several PCs or sharing library in a team (I use several laptops and just using GitHub)
• Database columns can easily be added and removed to adjust the user’s needs.
Your component can store a lot more information and it is easier to manage
Database library Cons:
• It takes some time to setup the library (for me it took about a week of work to create library structure, setup the library, transfer there all my components to it)
• When adding a lot of new components some things can be missed and noticed only when you use components in the project. Like wrong symbol or footprint name and no footprint is displayed for a component. However it’s easy to fix.
• Adding new components is not as fast as just copy-paste a resistor in a project and change a resistance value. You need to open database and add new component.
After adding new components or modifying in existing ones in a database, you need to close the KiCAD and reopen it.
Other concerns:
Q: what if I want to share my projects without sharing whole database library?
A: Create a copy of a project folder, that you want to share, then use “Export Symbols to new Library” and “Export Footprints to new Library” functions. In addition you can use “Archive 3D Models” plugin which exports and all 3D models and links them to new local footprint library. Now all project components are linked to a local project library within a project folder.
Q: What if I do not want to have one footprint for a component, for Example I can use THT electrolytic cap standing or bend component.
A: Just add Footprint Filters column to the database and add footprint later in a project which is filtered to display only suitable footprints.
Also, I want to thank the Official KiCAD Librarians as well as everyone that are contributing to the library, you guys are doing amazing job and saving hundreds of hours’ time for me and other developers.
And also I want to thank for AKL (Alternative KiCAD Library) creator Dawid Cisło for creating amazing library. I am using your component footprints and symbols a lot and they are great 
Most of my components symbols and footprints are either modified from Original library or AKL library, but some of them I create myself.
I added my instruction how to setup a library and my example database library to GitHub, with all the files:
Of course all criticism is welcome and I would like to hear your thoughts about it and other ideas, thanks
Keep up the good work!