# 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 - **ホームページ:** - **リポジトリ:** - **ライセンス:** MIT - **ソースアーカイブ:** - **最終更新:** 2026-06-22T14:03:09-07:00 - **生成日時:** 2026-08-04T22:13:35+00:00 ## 実行可能ファイル - dexter (cli) - dexter (エイリアス) ## 依存関係 - libpq - ruby ## インストール挙動 - post-install フック: 未定義 - Bottle: 利用可能 対象 arm64_linux, arm64_sequoia, arm64_sonoma, arm64_tahoe, sonoma, x86_64_linux ## バージョンと鮮度 - ページ生成日: 2026-08-04 - マネージャ版: 0.6.3 - マネージャ更新日: 2026-06-22 - ローカルデータ: OK - 上流リポジトリ: https://github.com/ankane/dexter - 検出された最新: v0.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. ### ソース - - - ## セキュリティノート narrow executable package without higher-risk signals. - **Geiger リスク:** グリーン / 低 - narrow executable package without higher-risk signals ## ソースデータベース詳細 - **Source Database:** Homebrew formula API - **Tap:** homebrew/core - **Full Name:** dexter - **Version Scheme:** 0 - **Revision:** 1 - **Conflicts With:** dexter-lsp - **Bottle Stable Root URL:** - **Deprecated:** no - **Disabled:** no - **Keg Only:** no - **URL Keys:** stable ## 他のパッケージマネージャ記録 - 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 ## 関連リンク - [Source-control packages](https://pkg.so/ja/source-control-tools/) - Belongs to a source-control command family. - [Terminal utility packages](https://pkg.so/ja/terminal-utilities/) - Matched terminal and command-line workflow metadata. - [Text processing packages](https://pkg.so/ja/text-processing-tools/) - Matched text, document, or structured-data processing metadata. - [Networking and protocol packages](https://pkg.so/ja/networking-protocol-tools/) - Matched network, protocol, or remote-service metadata. - [ruby](https://pkg.so/ja/brew/ruby/) - Runtime dependency declared by Homebrew. - [libpq](https://pkg.so/ja/brew/libpq/) - Runtime dependency declared by Homebrew. - [postgresql@14](https://pkg.so/ja/brew/postgresql-14/) - Shares pkgdb curated category or tags: cli, data, database, postgresql. - [postgresql@16](https://pkg.so/ja/brew/postgresql-16/) - Shares pkgdb curated category or tags: cli, data, database, postgresql. - [postgresql@17](https://pkg.so/ja/brew/postgresql-17/) - Shares pkgdb curated category or tags: cli, data, database, postgresql. - [postgresql@18](https://pkg.so/ja/brew/postgresql-18/) - Shares pkgdb curated category or tags: cli, data, database, postgresql. - [postgresql@15](https://pkg.so/ja/brew/postgresql-15/) - Shares pkgdb curated category or tags: cli, data, database, postgresql. - [postgis](https://pkg.so/ja/brew/postgis/) - Shares pkgdb curated category or tags: cli, data, database, postgresql. - [lazysql](https://pkg.so/ja/brew/lazysql/) - Shares pkgdb curated category or tags: cli, data, database, postgresql. - [doltgres](https://pkg.so/ja/brew/doltgres/) - Shares pkgdb curated category or tags: cli, data, database, postgresql. - [pgslice](https://pkg.so/ja/brew/pgslice/) - Both packages touch the same language runtime or ecosystem. Shared terms: cli, data, database, libpq, postgres. - [pgsync](https://pkg.so/ja/brew/pgsync/) - Both packages touch the same language runtime or ecosystem. Shared terms: cli, data, database, libpq, postgres. - [kitchen-sync](https://pkg.so/ja/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) ## ソース - 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