# Installer dexter avec Homebrew, Nix

Consultez les chemins d'installation, exécutables, métadonnées et notes de sécurité de dexter pour les workflows d'agents IA.

## installation

```sh
sudo av install brew:dexter
```

Commandes d'installation supplémentaires:

### macOS

- Homebrew (100%):

```sh
brew install dexter
```

  Preuve: local Homebrew formula metadata

### Linux

- Nix (92%):

```sh
nix profile install nixpkgs#dexter
```

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

## Faits du paquet

- **Clé du paquet:** brew:dexter
- **Gestionnaire de paquets:** Homebrew
- **Page du gestionnaire de paquets:** <https://formulae.brew.sh/formula/dexter>
- **Version:** 0.6.3
- **Résumé source:** Automatic indexer for Postgres
- **Page d'accueil:** <https://github.com/ankane/dexter>
- **Dépôt:** <https://github.com/ankane/dexter>
- **Licence:** MIT
- **Archive source:** <https://github.com/ankane/dexter/archive/refs/tags/v0.6.3.tar.gz>
- **Dernière mise à jour:** 2026-06-22T14:03:09-07:00
- **Généré:** 2026-08-04T22:13:35+00:00

## exécutables

- dexter (cli)
- dexter (alias)

## Dépendances

- libpq
- ruby

## Comportement d'installation

- hook post-installation: non défini
- Bouteille: disponible sur arm64_linux, arm64_sequoia, arm64_sonoma, arm64_tahoe, sonoma, x86_64_linux

## Version et fraîcheur

- page générée: 2026-08-04
- version du gestionnaire: 0.6.3
- gestionnaire mis à jour: 2026-06-22
- données locales: OK
- dépôt amont: https://github.com/ankane/dexter
- dernière version détectée: v0.6.3 (à jour)
## Historique du projet et usages

Dexter is an automatic index recommender for PostgreSQL that analyzes query sources and proposes indexes using HypoPG before optionally creating them.

### Historique du projet

The official tag history starts in 2017, and the changelog shows a steady 0.x series focused on safer index suggestions, more input sources, PostgreSQL compatibility, Docker and Linux packaging, and support for newer Ruby and PostgreSQL versions.

### Historique d'adoption

Dexter entered the PostgreSQL performance-tool niche as a command-line utility that can read pg_stat_statements, live activity, log files, SQL files, and stdin. Its README documents installation through RubyGems, Docker, Homebrew, and Linux packages.

### Modes d'utilisation

A typical run points Dexter at a database and a query source, such as `dexter -d dbname --pg-stat-statements`. By default it reports candidate indexes; creating indexes requires an explicit `--create` flag.

### Pourquoi les passionnés de paquets s'y intéressent

The package is notable because it bridges application-level package managers and database-server extension packaging: the CLI is easy to install, but useful operation also depends on HypoPG being present and enabled on the PostgreSQL server.

### Chronologie

- 2017: v0.1.0 appears in the official tag history.
- 2017: early releases add pg_stat_statements, psql-style connection options, CSV input, multicolumn indexes, and schema support.
- 2023: v0.5.0 adds normalized-query support and changes several input and HypoPG safety defaults.
- 2025: v0.6.0 adds Linux packages for Ubuntu 24.04 and Debian 12 while dropping older runtime support.

### Related projects

- Dexter is tightly related to PostgreSQL, pg_stat_statements, pg_stat_activity, server log analysis, pg_query, and the HypoPG extension for hypothetical indexes.

### Sources

- <https://github.com/ankane/dexter#readme>
- <https://github.com/ankane/dexter/blob/master/CHANGELOG.md>
- <https://github.com/ankane/dexter/tags>


## Notes de sécurité

narrow executable package without higher-risk signals.

- **Risque Geiger:** vert / faible
- narrow executable package without higher-risk signals

## Détails de la base source

- **Source Database:** Homebrew formula API
- **Tap:** homebrew/core
- **Full Name:** dexter
- **Version Scheme:** 0
- **Revision:** 1
- **Conflicts With:** dexter-lsp
- **Bottle Stable Root URL:** <https://ghcr.io/v2/homebrew/core>
- **Deprecated:** no
- **Disabled:** no
- **Keg Only:** no
- **URL Keys:** stable

## Autres enregistrements de gestionnaires de paquets

- Nix - dexter: normalized package name match | nixpkgs package indexes: pkgs/by-name/de/dexter/package.nix from https://api.github.com/repos/NixOS/nixpkgs/git/trees/master?recursive=1


## Liens liés

- [Source-control packages](https://pkg.so/fr/source-control-tools/) - Belongs to a source-control command family.
- [Terminal utility packages](https://pkg.so/fr/terminal-utilities/) - Matched terminal and command-line workflow metadata.
- [Text processing packages](https://pkg.so/fr/text-processing-tools/) - Matched text, document, or structured-data processing metadata.
- [Networking and protocol packages](https://pkg.so/fr/networking-protocol-tools/) - Matched network, protocol, or remote-service metadata.
- [ruby](https://pkg.so/fr/brew/ruby/) - Runtime dependency declared by Homebrew.
- [libpq](https://pkg.so/fr/brew/libpq/) - Runtime dependency declared by Homebrew.
- [postgresql@14](https://pkg.so/fr/brew/postgresql-14/) - Shares pkgdb curated category or tags: cli, data, database, postgresql.
- [postgresql@16](https://pkg.so/fr/brew/postgresql-16/) - Shares pkgdb curated category or tags: cli, data, database, postgresql.
- [postgresql@17](https://pkg.so/fr/brew/postgresql-17/) - Shares pkgdb curated category or tags: cli, data, database, postgresql.
- [postgresql@18](https://pkg.so/fr/brew/postgresql-18/) - Shares pkgdb curated category or tags: cli, data, database, postgresql.
- [postgresql@15](https://pkg.so/fr/brew/postgresql-15/) - Shares pkgdb curated category or tags: cli, data, database, postgresql.
- [postgis](https://pkg.so/fr/brew/postgis/) - Shares pkgdb curated category or tags: cli, data, database, postgresql.
- [lazysql](https://pkg.so/fr/brew/lazysql/) - Shares pkgdb curated category or tags: cli, data, database, postgresql.
- [doltgres](https://pkg.so/fr/brew/doltgres/) - Shares pkgdb curated category or tags: cli, data, database, postgresql.
- [pgslice](https://pkg.so/fr/brew/pgslice/) - Both packages touch the same language runtime or ecosystem. Shared terms: cli, data, database, libpq, postgres.
- [pgsync](https://pkg.so/fr/brew/pgsync/) - Both packages touch the same language runtime or ecosystem. Shared terms: cli, data, database, libpq, postgres.
- [kitchen-sync](https://pkg.so/fr/brew/kitchen-sync/) - Local metadata places this package in an adjacent workflow. Shared terms: cli, data, database, libpq, postgresql.

## Combined YAML source

View the package source record on GitHub. [combined/dexter.yml](https://github.com/mxcl/pkgdb/blob/main/combined/dexter.yml)


## Sources

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