# dexter を Homebrew, Nix でインストール

dexter のインストール経路、実行ファイル、メタデータ、AI エージェント向けセキュリティノートを確認します。

## インストール

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

追加のインストールコマンド:

### macOS

- Homebrew (100%):

```sh
brew install dexter
```

  証拠: local Homebrew formula metadata

### Linux

- Nix (92%):

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

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

## パッケージ情報

- **パッケージキー:** brew:dexter
- **パッケージマネージャ:** Homebrew
- **バージョン:** 0.6.3
- **ソース概要:** Automatic indexer for Postgres
- **ホームページ:** <https://github.com/ankane/dexter>
- **リポジトリ:** <https://github.com/ankane/dexter>
- **最終更新:** 2026-06-22T14:03:09-07:00
- **生成日時:** 2026-08-03T19:37:03+00:00

## 実行可能ファイル

- dexter (エイリアス)

## インストール挙動

- Bottle: 利用不可

## バージョンと鮮度

- ページ生成日: 2026-08-03
- マネージャ版: 0.6.3
## プロジェクトの歴史と使われ方

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

### プロジェクトの歴史

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.

### 採用の歴史

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.

### 使われ方

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.

### パッケージ好きにとっての重要性

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.

### タイムライン

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

### ソース

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


## セキュリティノート

narrow executable package without higher-risk signals.

- **Geiger リスク:** グリーン / 低
- narrow executable package without higher-risk signals

## 他のパッケージマネージャ記録

- 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


## Combined YAML source

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


## ソース

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