Is pgvector required?

While it installs pgvector by default to support modern AI workflows, you can use the resulting PostgreSQL instance for any standard relational database tasks.

Which version of PostgreSQL is installed?

The skill currently defaults to PostgreSQL version 16, which provides a stable foundation for the pgvector extension.

How does it handle database security?

It generates strong 16-character random passwords by default, configures specific user privileges, and sets secure 600 permissions on sensitive files like .pgpass.

Does this skill work on Linux or Windows?

No, this skill is specifically designed for macOS as it relies on Homebrew for package management and macOS-specific service commands.

Can I use this to manage an existing PostgreSQL installation?

Yes, the skill includes a pre-check step that detects existing installations and allows you to skip to configuration or service management.

Init PostgreSQL Mac

Name: Init PostgreSQL Mac
Author: yanmxa

byyanmxa

•

Database Management

Automates the installation, configuration, and lifecycle management of PostgreSQL with the pgvector extension on macOS.

The init-postgres-mac skill provides a comprehensive workflow for managing PostgreSQL on macOS using Homebrew. It handles the entire lifecycle of a database environment, from initial installation and pgvector extension setup to service management (start/stop/restart) and secure uninstallation. Beyond simple installation, it automates the creation of databases, users, and configuration files like .env and database.yaml, ensuring your local development environment is production-ready and optimized for AI-driven applications requiring vector similarity search.

Key Features

01Interactive or automated database, user, and password configuration

029 GitHub stars

03Automated Homebrew installation of PostgreSQL 16 and pgvector

04Built-in similarity search reference and troubleshooting tools

05Automatic generation of .env, database.yaml, and .pgpass files

06Full service control including start, stop, restart, and status checks

Use Cases

01Rapidly provisioning a new PostgreSQL instance with standardized project configurations

02Setting up a local development environment for AI applications requiring vector embeddings

03Managing and troubleshooting local database services through a unified interface

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add yanmxa/cc-plugins init-postgres-mac

For use in Claude.ai and ChatGPT

Download Skill