issus/altium-library

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

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!

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.

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.

Sponsors

$100/mo Sponsor: Cofactr’s procurement tools, inventory management, and automated kitting get you to manufacturing faster and easier than ever.

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.

---

altium-library's Issues

Clarify dependencies

I get the following error, but only for this library. Other dblibs (Excel based) seem to work just fine, so at least some form of the dependencies have been satisfied. Is there some other runtime dependency?

Not receiving an activation email

I tried to resend the activation email a few times, but i am still not getting an email that contains the activation code.

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

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

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

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.

Component not showing

Hello,

The components are not showing after installation... Any idea ?

Thanks !

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.

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:

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).

Can this be a server-side problem?

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.

Access from China

Hi, I found that the access to the database from China is not possible. When opening the file Altium hangs for a long time to the point it stops working. If the db is installed as a library, when placing a component hangs for long time and then the lists are empty. Some days ago I went to Macau and everything loaded perfectly, but when I came back to mainland it immediately stopped working.

Windows 10 x64
Altium 20.0.11

Please specify exactly what MSSQL software is required and how to install it

The signup confirmation email said:

If you have connection issues, then you may be missing the MSSQL driver on your computer, you can download it here:
https://www.microsoft.com/en-us/download/details.aspx?id=29065

So I went to that page and clicked "Download." The resulting download, bizarrely, was just a confusing text file with, like, country road driving directions to the download, and a note saying:

please be certain to pick the appropriate component architecture for download.

I'd... like to be certain!? Either I need a better link, or more specific requirements info.

Error " Microsoft SQL Server Native Client11.0" login failed for user " "

I had my library working for some time, but then I forgot my password and tried every single password I ever used, but still not working. Due to the fact that there is no restore password option, I created another account and activated it. The azure software is accepting my credentials but the udl is showing this error

I created another account after that, but still the same issue, is there anything I can do for that.

Is there an automated way of generating the symbol/footprint images?

Hi,

I am new to this library and still exploring the capabilities, however I intend keeping the symbol/footprint library in sync with the images in PNG format.

Is there an easy/automated way for generating the image of the symbols/footprints after they are added to the library?

I typical scenario would be adding bunch of new components to the library and running a script/tool to generate the images for the new components in "images" folder.

Thank you in advance

can't connect to sql database

Hello
when i double click on .udl file and click test connection i get error that login failed for user ,
my username and password is correct in .udl file..

BM04B-SRSS-TB(LF)(SN) has wrong footprint.

It should look like this:

Use without Celestial ADB Desktop

Can I use this library without CelestialADBDesktop?

[Suggestion] Add Yageo RC series resistors as Panasonic alternatives

Hi,
I appreciate this great library.
Could you please add Yageo RC series resistors for common values and cases like 0402, 0603 and 0805?
I see there are already some Yageo resistors but most values are not present.

Thanks very much and happy new year!

Clone the SQL Library

Hello,
is it possible to clone the SQL library since our university is not able to open the ports to accesss the library within the university network.

Best regards,

Jonas Frey
ETH Zurich

Wrong parameters in DB

The following components from the RF - Transceiver ICs table:

• CC1125RHBR
• CC1125RHBT
• CC1120RHBR
• CC1120RHBT

Have "32-VQFN (5x)" as their "Protocol".

Password not complex enough for AzureSQL

Hi

I am having a problem with registering the account. All the time I am getting error message:
"Password not complex enough for AzureSQL"

I have tried many passwords but still the same.
I have even tried 64 characters passwords like this:
"z8yE3txadzFMXDGPf0W4eC5C9Ny7rpQOmdjdwEdz3H9RaFuftg8yG1YGEnBTChxM" still the same.

Any suggestions ?

Import Guide

Hello

First of all, thank you for great effor and sharing such a great work.

I want to implement your library. But i am getting some erros when i install/implement to this library.

I dont have any sql server on my computer. Should i?

Can you guide me from the zero point to do the necessary things?

I have added some components that you dont have in your lib and some of them on your to list components.

I will be wait for your reply. Thanks a lot..

Removed from discord server twice without any explanation or reason

For the second time in a month I've been removed from the discord server without any explanation.
Is this an automatic removal for some activity (I didn't do anything retarded to the best of my knowledge)?

I don't remember the removal context last time, but this time I posted a link to a specific discord message (on this same server) which was linking to ECAD/MCAD contribution guide. Shortly after I was no longer in the server.

So uh, what?

Wrong parameters in inductor library

There's a lot of components on the inductors - RF table which have the "Package / case" set to
0402 (1006 Metric)
This is probably a typo and should read:
0402 (1005 Metric)

Relays not to be found

I am unable to find any relay in the database, no subcategory either in which I would find it logical?
Any help is appreciated.

BR Emiel

Error when trying to establish account or donate for SSL cert.

I received and error when the desktop application tries to send the activation email. I double checked the email address and even tried an alternate. The error message: "an error has occurred". Not that it helps... My sys. is Windows 7,64 Bit. Also, when attempting to donate for the SSL cert., gofundme says there is some sort of problem with the account. Probably something simple.

issues in rectangular connector library

IDC box header .050" 10 POS doesn't have number of positions and number of rows filled in

CONN HEADER GH SIDE 2POS 1.25MM 3D view is only a box extrusion

SQL Remote Queries inefficiencies

First I want to say thanks for this project. I can't wait to see the library grow bigger and bigger.

Now to the problem:

I noticed that sometimes when selecting components it would get stuck for about a minute before I could place the component. I just checked the packet activity using Wireshark and noticed that when selecting a specific component I got about 215 requests to 51.89.172.95 which I presume is the SQL database server. This particular case took 45 seconds. I am in Uruguay, so the latency really adds up.

Upon further inspection, it looks like when selecting a component in a specific library a remote query is made for each of the tables until it matches the containing table of that component. This means that components located in the first libraries work perfectly but those located on the latter libraries take a long time. Here are some of the SELECT queries, each a separate request:

Select [Footprint Ref], [Footprint Path] From [Amplifiers - Audio] Where [Footprint Ref] = 'CAP FILM 0805'

Select [Footprint Ref 2], [Footprint Path 2] From [Amplifiers - Audio] Where [Footprint Ref 2] = 'CAP FILM 0805'

Select [Footprint Ref 3], [Footprint Path 3] From [Amplifiers - Audio] Where [Footprint Ref 3] = 'CAP FILM 0805'

Select [Footprint Ref], [Footprint Path] From [Amplifiers - OP Amps and Buffer Amps] Where [Footprint Ref] = 'CAP FILM 0805'

Select [Footprint Ref 2], [Footprint Path 2] From [Amplifiers - OP Amps and Buffer Amps] Where [Footprint Ref 2] = 'CAP FILM 0805'

... and so on until it matches the component

This seems awfully inefficient. I'd suspect there should be only a single SQL request to the right table right away. Is this back and forth necessary? To make things worse this chain of requests is made even when placing repeated instances of the same object, which makes no sense.

I am not sure if this is an Altium shortcoming or something that can be fixed on your side (maybe have a single table/library with all the components?)

Any ideas?

Thanks!

How to install the library?

I read the Wiki page, but over there it uses a archived application (https://github.com/issus/CelestialADB-Desktop). So, how to use and install the library?

Thanks.

How to add components to your library?

Hi!
I really liked your library! But there are no components in it that I need, how can I add them?

Can't connect to server for some reason.

Hi all,

After spending my whole afternoon trying to get this to work, I gave up. I am unable to connect to the server.

I created my .udl file through celestial desktop manager

I then double clicked on the udl file and clicked 'test connections'

After waiting for about 5-10 secs, these are the error messages I am consistently getting.

I re-read the instructions and the error section several times and am still unable to get this to work. I have disabled firewall to try this and it is still not working.

Please help me!

Thank you,
Benjamin

Since I pulled the latest update, it took a long time to open Altium.

Since I pulled the latest update, it took a long time to open Altium. And Altium always loses response. Has anyone else encountered this problem?

A problem with the database

Hello ! ;)
I downloaded "altium-library" repository on disk. I would like to open the file "Celestial Library Database. DbLib", however, is not possible.

At the beginning i open Celestial Library Database in Altium, the next step
I removed from file mssql sample conn.udl**.txt** to -> mssql sample conn.udl
and i choose then I chose the mssql sample conn.udl

Can you explain how to access the database?

Studying at the Wroclaw University of Science and Technology and I have access to Microsoft Azure from Microsoft MSDN.

Thank you so much for all the help :).

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?

Missing symbols

I fetched the latest github but still many symbols are missing.
Am I doing something wrong?

For example P Mosfet NTR4101PT1G has no symbol, only footprint.

Change footprint name to fix ambiguities

The following footprint has an ambiguous name:
footprints/Leadless - DFN/PCB - LEADLESS - DFN - MAXIM TDFN-8 2X2MM.PCBLIB

Maxim has 10 differrent TDFN-8 packages (https://www.maximintegrated.com/en/design/packaging/package-information.html?a=2&f=), so the footprint name should include the Maxim variant-code as other maxim footprints do.

The correct variant-code is T822+2 in this case (extracted from the datasheet).
The footprint also has an exposed pad (noted with '-EP' in the maxim footprint name), maybe this should also be included in the footprint's name.

Server is down?

Is this project still running? I cannot contact with the server. How could I use the lib?

New password

I forgot my password, is it possible to reset the password somehow?

Wrong value in two Ceramic Caps

CAP CER 1UF 35V X5R 0402
C1005X5R1V105K050BC

and

CAP CER 1UF 35V X5R 0402
C1005X5R1V105M050BC

Has some mm as value in the Parameters.

AD 18.0.11 Hang when add a component in PcbDoc

I use Azure connection and the UI is frozen when i try to add a component in PcbDoc.

AD Version 18.0.11.
OS Version: windows 10.

PS: Add component in SchDoc is no problem.

How to extract components

How to extract components to local library after finding in database library. Is there any tool?

Cannot open server 'csql'

Hello,

I'm trying your open source library. Thank you for this ressource.

However, I have the following error when I try test the connection to the Azure server :
Cannot open server 'csql' requested by the login. Client with IP Adress 'xxxxxxxx' is not allowed to access the server. [...]

I already downloaded the Celestial Altium DB Deskstop software and it seems that my Azure access is valid.

Do you have a solution for this error ?

Thank you,

Cyril

Addressable RGB LED and mechanical keyswitch footprint

May I submit footprints and models for APA102-2020 RGB LEDS, and Kailh PG1350 switch sockets?

Cant connect database

When hit the connect button im getting error. What sould i do?

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:

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

Any idea to fix it??

Thanks!!

Slack link in the readme.md is dead

This invite link is no longer active.

Looking for someone to assist me

I have the database installed and it appears to work as I can place parts from it. But I have several questions.
If I want to place a part that is not in this library can I add it and if so how?
What if its a part in a category not currently in the database? How do I create one?
I am sure I will have more questions and if someone would be willing to answer them as they come up via email or phone I would be most grateful.

Jeff

LFS quota issue

Hello,

I tried to clone the repo, but unfortunately it failed during the "lfs fetch".
The github server answer with

batch response: http: This repository is over its data quota. Purchase more data packs to restore access.
Docs: https://help.github.com/articles/purchasing-additional-storage-and-bandwidth-for-a-personal-account/
Warning: errors occurred

I plan to setup an altium database so I am interested to see how it looks in the details.
Maybe it is possible for you to share a working version of this repo in an archive via wetransfer or something like that?

Regards

Part request for side entry JST-PH through hole connector

title, and preferably SMT ones as well

thanks.

http://www.jst-mfg.com/product/detail_e.php?series=199

Altium

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

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.