neki

Enable horizontal scaling for Postgres databases with PlanetScale-managed sharding.

6|1|Updated Nov 23, 2023
One-click install
npx skills add https://github.com/gmcabrita/dotfiles --skill neki
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: neki
Source: https://github.com/gmcabrita/dotfiles/tree/main/.agents/skills/neki
Command: npx skills add https://github.com/gmcabrita/dotfiles --skill neki

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Neki provides horizontal sharding for PostgreSQL, enabling scalable, highly available databases managed by PlanetScale.

Core Features & Use Cases

  • Sharded PostgreSQL: scales large multi-tenant workloads by distributing data across shards.
  • Managed by PlanetScale: operational reliability and simplified administration.
  • High availability: resilient infrastructure designed for production workloads.

Quick Start

Outline a starter shard plan for a multi-tenant Postgres app using Neki and identify a suitable shard key.

Frequently Asked Questions about neki

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I scale a multi-tenant Postgres database with horizontal sharding?

You can scale a multi-tenant Postgres database by applying horizontal sharding to distribute data across multiple shards. This approach uses a well-chosen shard key to ensure tenant isolation and distributed data storage across managed infrastructure.

When do I need to plan a shard key for a distributed data storage architecture?

Shard key planning is needed when your large-scale application requires horizontal scaling to distribute workloads. Choosing the right shard key ensures proper tenant isolation and balanced data distribution across your highly available Postgres infrastructure.

Can I use PlanetScale-managed infrastructure for high-availability Postgres workloads?

Yes, you can use PlanetScale-managed infrastructure for high-availability Postgres workloads. It provides operational reliability and simplified administration for resilient, production-grade distributed data storage environments.

What is the best way to outline a starter shard plan for a multi-tenant application?

The best way to outline a starter shard plan for a multi-tenant application is to identify a suitable shard key that ensures tenant isolation. This enables sharded PostgreSQL architecture to effectively distribute large workloads across managed infrastructure.

Does sharded PostgreSQL support tenant isolation for large-scale applications?

Sharded PostgreSQL supports tenant isolation for large-scale applications by distributing data across multiple shards. Using a well-chosen shard key, it maintains compatibility with Postgres workloads while providing distributed data storage and high availability.