# Install kitchen-sync with Homebrew, chocolatey, Nix

Fast efficiently sync database without dumping & reloading. Version 2.21 via Homebrew; verified 2026-06-25.

## Install

```sh
sudo av install brew:kitchen-sync
```

Additional install commands:

### macOS

- Homebrew (100%):

```sh
brew install kitchen-sync
```

  Evidence: local Homebrew formula metadata

### Linux

- Nix (92%):

```sh
nix profile install nixpkgs#ks
```

  Evidence: nixpkgs package indexes: pkgs/by-name/ks/ks/package.nix from https://api.github.com/repos/NixOS/nixpkgs/git/trees/master?recursive=1

### Windows

- Chocolatey (92%):

```sh
choco install KS
```

  Evidence: Chocolatey community package catalog: KS from http://community.chocolatey.org/api/v2/Packages?$filter=IsLatestVersion&$select=Id&$top=1000&$skiptoken='11','kb5001567'

## Package facts

- **Package key:** brew:kitchen-sync
- **Package manager:** Homebrew
- **Package manager page:** <https://formulae.brew.sh/formula/kitchen-sync>
- **Version:** 2.21
- **Source summary:** Fast efficiently sync database without dumping & reloading
- **Homepage:** <https://github.com/willbryant/kitchen_sync>
- **Repository:** <https://github.com/willbryant/kitchen_sync>
- **Upstream docs:** <https://github.com/willbryant/kitchen_sync#readme>
- **License:** MIT
- **Source archive:** <https://github.com/willbryant/kitchen_sync/archive/refs/tags/v2.21.tar.gz>
- **Last updated:** 2026-06-25T13:37:47+02:00
- **Generated:** 2026-07-08T07:18:31+00:00

## Executables

- ks (cli)
- ks_mysql (cli)
- ks_postgresql (cli)
- ks (alias)
- ks_mysql (alias)
- ks_postgresql (alias)

## Dependencies

- libpq
- mariadb-connector-c

## Build dependencies

- cmake

## Install behavior

- Post-install hook: not defined
- Bottle: available on arm64_linux, arm64_sequoia, arm64_sonoma, arm64_tahoe, arm64_ventura, sonoma, ventura, x86_64_linux

## Freshness

- Page generated: 2026-07-08
- Package-manager version: 2.21
- Package-manager updated: 2026-06-25
- Local data: ok
- Upstream repository: https://github.com/willbryant/kitchen_sync
- Upstream latest detected: v2.21 (current)
## Project history and usage

Kitchen Sync is a command-line database synchronization tool focused on making or updating a unidirectional database copy without dumping and reloading the entire source.

### Project history

The repository README frames Kitchen Sync around fast logical synchronization for developer, test, remote-office, and cross-database copy workflows. It supports MySQL-family databases and PostgreSQL, can work over SSH, can synchronize only changed data, and can filter sensitive columns as data is copied.

### Adoption history

Kitchen Sync has a modest but concrete package footprint, with the input facts listing Homebrew, Chocolatey, and Nix packaging. That distribution profile fits an operations-oriented CLI used by developers and database teams rather than a broad framework community.

### How it is used

Users run `ks` with source and target database URLs, optional filters, and worker settings to update a target database. The README example shows cross-engine synchronization from MySQL to PostgreSQL with a filtering file.

### Why package nerds care

Kitchen Sync is interesting as a small systems package because it addresses a dull but costly workflow: refreshing large database copies without the time, write amplification, and downtime of full dump-and-load cycles.

### Timeline

- 2020-03-14: GitHub release candidates 2.0rc1 through 2.0rc3 were published.
- 2023-10-29: GitHub release v2.19 was published.
- 2023-10-30: GitHub release v2.20 was published.
- 2025-04-15: GitHub release v2.21 was published.

### Related projects

- Kitchen Sync is related by use case to database dump/restore tooling, logical replication workflows, SSH tunneling, MySQL, MariaDB, Percona Server, and PostgreSQL.

### Sources

- <https://api.github.com/repos/willbryant/kitchen_sync/releases?per_page=100>
- <https://formulae.brew.sh/formula/kitchen-sync>
- <https://github.com/willbryant/kitchen_sync>
- <https://github.com/willbryant/kitchen_sync/releases>


## Security Notes

broad file, network, media, or database tool signal.

- **Geiger risk:** blue / medium
- broad file, network, media, or database tool signal

## Source Database Details

- **Source Database:** Homebrew formula API
- **Tap:** homebrew/core
- **Full Name:** kitchen-sync
- **Version Scheme:** 0
- **Revision:** 0
- **Head Version:** HEAD
- **Bottle Stable Root URL:** <https://ghcr.io/v2/homebrew/core>
- **Deprecated:** no
- **Disabled:** no
- **Keg Only:** no
- **URL Keys:** head, stable

## Other Package-Manager Records

- Nix - ks: installed executable or alias match | nixpkgs package indexes: pkgs/by-name/ks/ks/package.nix from https://api.github.com/repos/NixOS/nixpkgs/git/trees/master?recursive=1
- Chocolatey - KS: installed executable or alias match | Chocolatey community package catalog: KS from http://community.chocolatey.org/api/v2/Packages?$filter=IsLatestVersion&$select=Id&$top=1000&$skiptoken='11','kb5001567'


## Related links

- [Source-control packages](https://www.automicvault.com/pkg/source-control-tools/) - Belongs to a source-control command family.
- [Secret-risk packages](https://www.automicvault.com/pkg/secret-risk-packages/) - Has protected-tool coverage, approval-gate, or non-low Geiger security signals.
- [Terminal utility packages](https://www.automicvault.com/pkg/terminal-utilities/) - Matched terminal and command-line workflow metadata.
- [Text processing packages](https://www.automicvault.com/pkg/text-processing-tools/) - Matched text, document, or structured-data processing metadata.
- [libpq](https://www.automicvault.com/pkg/brew/libpq/) - Runtime dependency declared by Homebrew.
- [mariadb-connector-c](https://www.automicvault.com/pkg/brew/mariadb-connector-c/) - Runtime dependency declared by Homebrew.
- [cmake](https://www.automicvault.com/pkg/brew/cmake/) - Build dependency declared by Homebrew.
- [lazysql](https://www.automicvault.com/pkg/brew/lazysql/) - Shares av.db curated category or tags: cli, data, database, mysql, postgresql.
- [whodb-cli](https://www.automicvault.com/pkg/brew/whodb-cli/) - Shares av.db curated category or tags: cli, data, database, mysql, postgresql.
- [automysqlbackup](https://www.automicvault.com/pkg/brew/automysqlbackup/) - Shares av.db curated category or tags: cli, data, database, mysql.
- [dexter](https://www.automicvault.com/pkg/brew/dexter/) - Shares av.db curated category or tags: cli, data, database, postgresql.
- [doltgres](https://www.automicvault.com/pkg/brew/doltgres/) - Shares av.db curated category or tags: cli, data, database, postgresql.
- [dumpling](https://www.automicvault.com/pkg/brew/dumpling/) - Shares av.db curated category or tags: cli, data, database, mysql.
- [electric](https://www.automicvault.com/pkg/brew/electric/) - Shares av.db curated category or tags: cli, data, database, sync.
- [mysql](https://www.automicvault.com/pkg/brew/mysql/) - Shares av.db curated category or tags: cli, data, database, mysql.
- [mydumper](https://www.automicvault.com/pkg/brew/mydumper/) - Local metadata places this package in an adjacent workflow. Shared terms: cli, connector, data, database, mariadb.

## Combined YAML source

View the package source record on GitHub. [combined/kitchen-sync.yml](https://github.com/automic-vault/db/blob/main/combined/kitchen-sync.yml)


## Sources

- Nucleus package database
- Geiger risk classifier
- package-page enrichment
- curated package history
- package version freshness
- av.db category and tag curation
- package relationship graph
- external package-manager database matches
- cross-ecosystem install command graph
