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.

About

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

Interactive or automated database, user, and password configuration
9 GitHub stars
Automated Homebrew installation of PostgreSQL 16 and pgvector
Built-in similarity search reference and troubleshooting tools
Automatic generation of .env, database.yaml, and .pgpass files
Full service control including start, stop, restart, and status checks

Use Cases

Rapidly provisioning a new PostgreSQL instance with standardized project configurations
Setting up a local development environment for AI applications requiring vector embeddings
Managing and troubleshooting local database services through a unified interface

About

Key Features

Interactive or automated database, user, and password configuration
9 GitHub stars
Automated Homebrew installation of PostgreSQL 16 and pgvector
Built-in similarity search reference and troubleshooting tools
Automatic generation of .env, database.yaml, and .pgpass files
Full service control including start, stop, restart, and status checks

Use Cases

Rapidly provisioning a new PostgreSQL instance with standardized project configurations
Setting up a local development environment for AI applications requiring vector embeddings
Managing and troubleshooting local database services through a unified interface