Open source Altium Database Library with over 147,000 high quality components and full 3d models.

Overview

Library Component Count Built for Altium Website Portal

Celestial Altium Library

The Celestial Altium Library is a massive, free, open source database library for Altium Designer created by Altium Industry Expert Mark Harris. The database is hosted on a dedicated cloud platform built for the library, to ensure you always have the latest components.

The Celestial Altium Library was designed from conception to contain high-quality data, with accurate footprints and exceptional 3D models. It is free to use, and open source. The Celestial Altium Library contains a vast array of components already, and is under active development to expand component coverage.

Build your next project faster, create beautiful schematics and stunning 3D PCBs with the Celestial Altium Library.

Love electronics? Need help with the library? Join us on Discord!

Discord

Database Access

You can register for free access on the Altium Library Portal.

For full instructions, see the Celestial Library Website.

Why use an Altium DBLib over an Integrated Library?

The Celestial Altium Library database is cloud-hosted; as new components are added to the library, they are immediately available in Altium. The library's schematic symbols and PCB footprints are hosted in GitHub allowing you to quickly clone the latest library files to your computer if they are needed for the new components.

A database library creates the linkage between a schematic symbol and PCB footprint on your computer, and also provides all of the technical parameters and pricing data for a component. This connection allows the library to contain every real-world capacitor, resistor, and other component types, with relatively few files on your computer.

Altium Database libraries make you design your schematic with the part you are going to use, rather than a generic schematic symbol/footprint combination. Rather than selecting "RJ45 Jack," you instead choose Amphenol Commercial Products part number RJCSE538001. This component selection is reflected in your Bill of Materials - the entire BOM fills itself out, meaning no more trying to remember exactly what part you intended to put in there was, or what voltage that capacitor was. Even if you are using an ActiveBOM in your project, the library will save you time as you do not need to set component properties after placing each component.

Without the Celestial Altium Library, you might find yourself looking for passive components on supplier websites to find a low-cost option, and then searching for those parts in the Manufacturer Part Search panel in Altium. Once you find the part you want, you can assign the properties to the schematic symbol in your project. With the library, however, you can rapidly sort through thousands of components to narrow down the list of relevant parts and then place the cheapest in-stock option directly into your design - all with Altium. Components added with the library will generate an excellent bill of materials for your project with or without ActiveBOM.

Save time on the design, and significantly reduce errors by placing real-world parts directly from the library.

Why use the Library?

Data

All components in the database contain all relevant technical parameters, allowing you to search/filter within Altium for the part you require. If your design calls for a 1.0uF, 25V 0603 ceramic capacitor, open the 0603 ceramic capacitors list, group by value, then by voltage, and sort by price to find the cheapest option available.

enter image description here

Each component in the database contains a link to supplier pages and a link to the datasheet allowing rapid access to reference materials. As all technical parameters and pricing data is available, your BOM can be populated automatically with all relevant information for purchasing.

Footprints

Every component has a footprint that matches the manufacturer's recommended footprint, or if a recommendation is not available, an IPC Compliant footprint for the specific package sizing. Only highly standardized passive components utilize generic footprints; all other parts have manufacturer-specific land patterns.

Each footprint features a high quality, dimensionally accurate, correctly colored 3D model. Every 3D model in the library is created from scratch to the manufacturer's drawings. This attention to detail ensures excellent 3D collision checking and eases MCAD integration when designing enclosures and associated parts.

Every part's center position is where a pick and place machine's head should collect the component. For companies running an in house Pick and Place machine, this is very convenient and allows faster machine setup. Your pick and place export list for products built with the Celestial Altium Library contains centers in the correct location.

Symbols

Library symbols are standardized as much as possible. This standardization ensures you will find pins where you expect them to be, such as VCC in the top left, GND in the bottom left, user function pins on the right (controllable inputs/outputs). Standard protocols like SPI have the pins in the same order in every part where other library standards don't have a higher priority. All components within a database category have similar pin layouts/groupings where possible. This preciseness makes it extremely easy to read and follow schematics created with the library.

All passive components, such as resistors and capacitors, all have the same size symbol lead span, keeping your schematics tidy.

Contributing

Want to contribute? Great! Join us on Discord and let the community know what you can do, we'll find something for you!

License

The library does not follow a specific open-source license. The Celestial Altium license is simple:

  • You may use this library commercially in contract work, products for sale, or any other commercial project not related to selling footprints/symbols/3D models.
  • You may not charge anyone for the footprints, 3D models, or schematic symbols contained in this library.
  • You should give your clients a copy of this library, and you must attribute the source back to this website.
  • You may not claim credit for the work in this library unless you have contributed it yourself.

Comments
  • Local installation

    Local installation

    Update: install locally without MSSQL server

    Hello Mark!

    Firstly, I would like to thank you for your effort to share the awesome Celestial Altium library that you have compiled manually, I think the world would be a better place if more people possessed this kind of mindset.

    The problem

    I was somehow able to download the big Components.sql data file off of Github using

    git clone --depth 1 https://github.com/issus/altium-library.git altium-library
    cd altium-library
    

    and spent the last evening trying to deploy the database on my local machine having no prior experience with MS SQL server. I was having trouble just plain executing the 200-odd MB query using sqlcmd, as it was giving off a substantial amount of errors related to non-existent databases and columns.

    The solution

    After some manual tinkering, I believe I've found the culprit: the sql project is missing some statements and columns that prevent the query from executing smoothly on a fresh machine. Here's a list of things I had to do manually to be able to import the database:

    1. Install MS SQL Server (I used 2016) leaving the default Windows authentication enabled

    2. Add the missing fields to the DB\altium_library\Tables\Components.sql definition file:

       [SensingRange]                    NVARCHAR(50) NULL, 
       [ActuatorLevel]                   NVARCHAR(50) NULL, 
       [PartStatus]                      NVARCHAR(50) NULL, 
       [HeightAboveBoard]                NVARCHAR(50) NULL, 
       [ElectricalLife]                  VARCHAR(50) NULL, 
       [Axis]                            VARCHAR(50) NULL,
      
    3. Run PowerShell or CMD and navigate to the library definitions folder

      cd "DB\altium_library"
      
    4. Run sqlcmd -S localhost for an SQL prompt and create an empty database

      CREATE DATABASE altium_library
      GO
      EXIT
      
    5. Recreate the database structure by executing all query files in the folder (forfiles is available since Win7 at least)

      forfiles /s /m *.sql /c "cmd /c sqlcmd -S localhost -d altium_library -i @path"
      
    6. Run the big import command

      cd ..
      sqlcmd -S localhost -d altium_library -i "Components.sql" -o "output.log"
      
    7. Check for any errors in output.log. Normally, the file should just contain a bunch of repeating lines along the lines of (1 rows affected).

    8. Open Celestial Library Database.DbLib and use the following Connection string:

      Provider=SQLNCLI11.1;Integrated Security=SSPI;Persist Security Info=False;User ID="";Initial Catalog=altium_library;Data Source=localhost;Initial File Name="";Server SPN=""
      
    9. Test the connection and follow through with the rest of the installation instructons

    Now normally I would have made this a pull request but I'm not quite sure if the steps I have provided are optimal. Besides, I'm not quite keen on Github's fork mechanics that demand users create useless clones of projects that they never intended to host on their page, and that whole process generates needless amounts of fuss. Now, back to the point - if you could add the steps needed for the local installation, I believe that can save some trouble for new people. The whole idea of local cloning will also help in the long run, if (when) you forget to update the Azure subscription, and generally is better for maintainability.


    Using the opportunity, I would also like to ask you about the contribution model for the library. Are you planning to continue the development of this library, given how popular snapEDA is? If so, I couldn't find an easy way of adding the components to the library from the AD itself, maybe only using things like SVNDBLib, which again I'm not very familiar with. Am I missing something or the "community" update process (like adding new components) is indeed somewhat complicated? And another question: Would you be fine with someone distributing the library using Torrents? Not that I know anyone or am planning to do this, but I believe the deployment process could be done much quicker in this fashion. Please feel free to ignore these questions, though - I can fully understand how plowing through tons of messages on a public account can become a burden.

    opened by fedorg 26
  • New User activation code not sent and error

    New User activation code not sent and error

    similar to issue 10

    I have attempted to sign up, but cannot see the send button in the window (its below bottom of the window and does not allow for scrolling) i just hit tab 2 times and then enter, which takes me to the activation code window.

    No activation email sent so I hit resend. An error has occurred shows, without any email sent.

    I checked spam.

    desktop create account altium

    error occured resend

    Also is there a lost username/password? I want to reuse the same email I have been using but forgot my password and get the following error: no reuse email

    opened by LGKev 10
  • MySQL support

    MySQL support

    I’m sending you a pull request for some changes to the Celestial database. Its really rough. Not actually meant for you to pull, but more just to get the conversation started, so you can see what I changed.

    Actually I haven’t had time to play with Celestial until now. My ISP changed my IP address and I wasn’t able to access it. I found another way to grab the DB using skyvia.com.

    For various reasons I wanted to get this DB running locally, using a MySQL backend rather than Azure. Well, it seems to be working, and it’s pretty fast. Way faster than my company database hosted on some beefy MSSQL server. (But this stuff is for hobby not work.)

    So, when you have time, have a look at the diff:

    • I pulled your Celestial DB and exported it as CSV.
    • Python script to convert this CSV, and your views, to MySQL syntax and import to a local DB.
    • New DbLib file to use it.

    As a side note, I noticed a gzipped version of the full DB is only 1.6MB. Might actually be feasible to check that in, I don’t know.

    A few questions for you:

    • I understand why the main Component.sql file was converted to git-lfs. But why were the Views/*.sql also converted? These are small files.
    • I am unable to clone the repo when I have git lfs tracking the .sql files. It fails to download them, (presumably due to quota), and then the rest of the clone fails. Had to turn off lfs tracking to get it to succeed. So bottom line, I can’t see your latest Views/*.sql files.
    • So I branched off of your July 2016 commit that still had the Views in sql in the repo. I don’t imagine they have changed much (if it all) since then.
    opened by bkuschak 7
  • Database connection error - Access Database Engine x64 already installed

    Database connection error - Access Database Engine x64 already installed

    Hi!!

    I'm trying to install de database following the steps of "http://altiumlibrary.com/GetStarted/ConfigureAltium", but Altium gives me the next error:

    error altium

    I installed the Access engine from microsoft web, but i can't get a sucessfull connection.

    Any idea to fix it??

    Thanks!!

    opened by patxi-dpg 6
  • can't connect to Azure?

    can't connect to Azure?

    Not sure if this is an issue for this repo or for the windows app repo, but after the UDL file is written, Altium can't connect to anything using it. And since I'm on 64-bit Win7 I can't even open the UDL to see what's in there. The tricks for opening a 32-bit UDL on a 64-bit system don't seem to work either.

    Can't I get the host/port and give my auth credentials manually and skip the UDL? For the time being I just downloaded the MDB and am using local database access, but that's suboptimal for what looks to be a promising replacement/augmentation of Altium's vault.

    opened by akohlsmith 6
  • Celestial Library Slowing Altium Down

    Celestial Library Slowing Altium Down

    Hi,

    After i installed the Celestial Library my Altium became extremely slow in some operations. Like, change a component footprint, update the PCB from the schematic.

    After a lot of research i figure it out why.

    When certain operations are performed, the library itself open a connection to the database and execute several query's (more the 10k).

    The problem is that from my location the latency to the DB server (db.altiumlibrary.com) is huge (200 ms).

    For me this could be solved, by making the database locally or with a closer mirror to my location. But i could not find the DB data in github, not connect to the database server to dump the tables.

    Anyone else with the same problem?

    Can someone provide me a database backup? So I can use a local server to confirm if this fix the issue or not.

    Thanks

    opened by thiagossrs 5
  • Celestial Library Vastly Slowing Altium Down

    Celestial Library Vastly Slowing Altium Down

    Some days when using the library Altium will become unusable. If I even try to move a component in the schematic Altium will lock up for about a minute. Even after restarting my pc the issue is intermittent. Sometimes it immediately returns after a fresh restart. When I close the library the issue disappears. Don't know what else too add that could help.

    I have a 4790k, 32gb ram, gtx 980 ti and everything is on an ssd.

    opened by airexes 5
  • Connect to Azure failed

    Connect to Azure failed

    Hi! I've done all the setup through desktop tool as described here, cloned the repo, but Altium still wouldn't connect to the database (see screenshot attached). default Can this be a server-side problem?

    opened by zserg8 5
  • Mouser Supplier Link

    Mouser Supplier Link

    Hi, I couldn't find the supplier information except for digikey. Is there any help you guys can provide so I can add mouser entries in the database for the components I'm using?

    opened by mumairanwar92 4
  • No designator on assembly layer

    No designator on assembly layer

    There is no reference designator text on the assembly layer for these library parts.

    I know this text isn't necessary if Draftsman is used to make the assembly drawing, but I can't get Draftsman to create an assembly drawing in the project that is using this library. Similarly, I have issues with using the project releaser with this library.

    opened by wdecook 4
  • Resetting the dblib file causes ODBC error

    Resetting the dblib file causes ODBC error

    I am using altium 17 and was able to add the library successfully and no problem so far. However my disk is getting full and wanted to change the library folder so I removed the dblib file in the "Available Libraries" menu as below image And then copy everything in the altium-library folder into different location and install the dblib file again. But after that, I am only getting these message saying "EOleException error executing: Select * From [Whatever parts] Cannot find supplier. May not installed properly" as below image

    It seems like Altium is still trying to find the old DB instead of new one. How can I solve this issue? Thanks,

    opened by kyuhyong 3
  • Server password

    Server password

    I'm attempting to set a server login up so I can create a local copy of the database bet when I go to set the server login password it returns an error.

    Error. An error occurred while processing your request.

    Anyone else having this issue

    opened by ChristianLees 0
  • W25Q40CLSNIG wrong footprint

    W25Q40CLSNIG wrong footprint

    Hi there, flash memory W25Q40CLSNIG has assigned a wrong variant of 8-Pin SOIC, which is 208-mil instead of 150-mil. W25Q40CLSNIG is 8-Pin SOIC8 150-mil W25Q40CLSSIG is 8-Pin SOIC8 208-mil Datasheet

    opened by aaajs 0
  • Added MICROCHIP PT TQFP-100 12X12 with step model

    Added MICROCHIP PT TQFP-100 12X12 with step model

    Solder mask swell set to zero, because pin clearance == 0.2mm. No way to have mask bridges with class 3 PCBs (guided by JLCPCB specs for green mask only)

    opened by AlxrMironovOldAcc 0
Owner
Mark
Technical Content Writer for Altium
Mark
The open-source tool for creating of 3D models

The open-source tool for creating of 3D models

3D geoinformation research group at TU Delft 428 Dec 21, 2022
Cocos2d-x is a suite of open-source, cross-platform, game-development tools used by millions of developers all over the world.

Cocos2d-x is a suite of open-source, cross-platform, game-development tools used by millions of developers all over the world.

cocos2d 16.7k Dec 26, 2022
A set of open c++ game development tools that are lightweight, easy-to-integrate and free to use. Currently hosting a magicavoxel .vox full scene loader.

open game tools Open game tools is a set of unencumbered, free, lightweight, easy-to-integrate tools for use in game development. So far it contains:

null 291 Dec 29, 2022
Full-body tracking in VR using AprilTag markers.

Full-body tracking in VR using AprilTag markers.

null 879 Jan 8, 2023
NVRHI (NVIDIA Rendering Hardware Interface) is a library that implements a common abstraction layer over multiple graphics APIs

NVRHI Introduction NVRHI (NVIDIA Rendering Hardware Interface) is a library that implements a common abstraction layer over multiple graphics APIs (GA

NVIDIA GameWorks 445 Jan 3, 2023
Sampling Clear Sky Models using Truncated Gaussian Mixtures

Sampling Clear Sky Models using Truncated Gaussian Mixtures Overview This repository contains the source code that is part of the supplemental materia

Computer Graphics AUEB 12 Aug 9, 2022
This Project Implement an interactive camera for 3D model using Quaternion. It have some advantages over eulerian camera like no gimbal lock and faster to compute.

Quaternion-Camera This Project Implement an interactive camera for 3D model using Quaternion. It have some advantages over eulerian camera like no gim

Phan Sang 8 Nov 10, 2022
StereoKit is an easy-to-use open source mixed reality library for building HoloLens and VR applications with C# and OpenXR!

StereoKit is an easy-to-use open source mixed reality library for building HoloLens and VR applications with C# and OpenXR! Inspired by libraries like XNA and Processing, StereoKit is meant to be fun to use and easy to develop with, yet still quite capable of creating professional and business ready software.

Nick Klingensmith 730 Jan 4, 2023
OpenCorr is an open source C++ library for development of 2D, 3D/stereo, and volumetric digital image correlation

OpenCorr OpenCorr is an open source C++ library for development of 2D, 3D/stereo, and volumetric digital image correlation. It aims to provide a devel

Zhenyu Jiang 66 Jan 6, 2023
Vizzu is a free, open-source Javascript/C++ library for animated data visualizations and data stories.

Vizzu is a free, open-source Javascript/C++ library utilizing a generic dataviz engine that generates many types of charts and seamlessly animates between them

Vizzu 1.6k Jan 3, 2023
An Open-Source subdivision surface library.

OpenSubdiv OpenSubdiv is a set of open source libraries that implement high performance subdivision surface (subdiv) evaluation on massively parallel

Pixar Animation Studios 2.7k Jan 2, 2023
Open 3D Engine (O3DE) is an Apache 2.0-licensed multi-platform AAA Open 3D Engine

Open 3D Engine (O3DE) is an Apache 2.0-licensed multi-platform 3D engine that enables developers and content creators to build AAA games, cinema-quality 3D worlds, and high-fidelity simulations without any fees or commercial obligations.

O3DE 5.8k Jan 7, 2023
appleseed is an open source, physically-based global illumination rendering engine primarily designed for animation and visual effects.

appleseed is an open source, physically-based global illumination rendering engine primarily designed for animation and visual effects.

appleseedhq 2k Jan 8, 2023
An open-source implementation of Autodesk's FBX

SmallFBX An open-source implementation of Autodesk's FBX that is capable of import & export mesh, blend shape, skin, and animations. Mainly intended t

Seiya Ishibashi 43 Dec 21, 2022
Tesseract Open Source OCR Engine (main repository)

Tesseract OCR Table of Contents Tesseract OCR About Brief history Installing Tesseract Running Tesseract For developers Support License Dependencies L

null 48.2k Jan 2, 2023
A completely free, open-source, 2D game engine built on proven torque technology.

Torque2D 4.0 Early Access 1 MIT Licensed Open Source version of Torque2D from GarageGames. Maintained by the Torque Game Engines team and contribution

Torque Game Engines 692 Jan 9, 2023
Open-Source Vulkan C++ API

Vulkan-Hpp: C++ Bindings for Vulkan The goal of the Vulkan-Hpp is to provide header only C++ bindings for the Vulkan C API to improve the developers V

The Khronos Group 2.5k Jan 8, 2023
ZBar Bar Code Reader is an open source software suite for reading bar codes from various sources

ZBar Bar Code Reader is an open source software suite for reading bar codes from various sources

null 2.4k Dec 26, 2022
Open-source, cross-platform, C++ game engine for creating 2D/3D games.

GamePlay v3.0.0 GamePlay is an open-source, cross-platform, C++ game framework/engine for creating 2D/3D mobile and desktop games. Website Wiki API De

gameplay3d 3.9k Jan 2, 2023