# headscalebacktosqlite

**Repository Path**: mirrors_samcday/headscalebacktosqlite

## Basic Information

- **Project Name**: headscalebacktosqlite
- **Description**: Headscale PSQL Back to SQLITE
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: main
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2025-09-26
- **Last Updated**: 2026-01-04

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# headscalebacktosqlite
I've made and tested this script to help me go from a v0.23.0 PSQL instance back to SQLITE (convert.py)
EDIT 2025-04-01
I've also made one to convert v0.22.3 (22.3_only.py) - this one can take up to 4 arguments:
python 22.3_only.py {username/schema_namespace} {password} {server_url/ip} {database_name}

Obviously take backups before you do this.

I would strongly suggest testing the resulting sqlite database without your production nodes phoning home to it. Test making a user, register a device that isn't part of your production tailnet with a route and enable the route. If all that works you shoud be good to go.

Loose instructions:
1. Make a blank v0.23.0 sqlite.db by running headscale without a database file and the default ```config.yaml```
2. Make a new python env from the directory you want to work in ```python -m venv .```
3. Install dependencies: ```pip install psycopg2-binary pandas SQLAlchemy```
4. Update the ```convert.py``` with the credentials of your psql db just as your headscale config has been accessing the server
5. Run ```python convert.py```