astrostash

🔭 An astronomy and astrophysics database building/syncing tool

Astrostash lets you "stash" query results from astronomy data sources into a local SQLite or PostgreSQL database by caching individual queries, or mirroring entire catalog tables for offline or internal access.

Features

• Local data storage — Retain copies of query results in a SQLite or PostgreSQL database.
• Offline querying — Mirror stable catalog tables and query them with spatial filters without network access.
• Automatic caching — Results from repeated queries are served from your local database.
• Refresh scheduling — Set a refresh interval to keep cached data up to date.
• Data products — Locate and download associated data files (FITS, etc.) and track local paths in the database.

Requirements

Python >= 3.10

📦 Dependencies

• astroquery >= 0.4.10
• pandas >= 2.3.0
• SQLAlchemy >= 2.0.43

📥 Installation

pip install astrostash

With PostgreSQL support:

pip install astrostash[postgres]

Or clone and install from source:

git clone https://github.com/nkphysics/astrostash.git
cd astrostash
pip install .

For info on Getting Started see the docs linked below.

📚 Documentation

• HEASARC — Quickstart, local mirroring workflow, spatial queries, data products, and full API reference.
• Development — Development setup, running tests, and PostgreSQL testing with Docker.

Development

🚧 Current State: Beta

Install dev dependencies:

pip install .[dev]

License

BSD 3-Clause. See LICENSE for details.