skills.rest
victorhramos-dev
victorhramos-devCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

ais-database

Generate PostgreSQL 15+ schema and migrations for AIS maritime data.

1|Updated Feb 5, 2026
Search Tags:#indexing#database#postgresql#migrations#schema#partitioning#ais
One-click install
npx skills add https://github.com/victorhramos-dev/ais_ai --skill ais-database
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: ais-database
Source: https://github.com/victorhramos-dev/ais_ai/tree/main/.claude/skills/ais-database
Command: npx skills add https://github.com/victorhramos-dev/ais_ai --skill ais-database

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill provides a ready-to-use PostgreSQL schema and migrations tailored for AIS maritime data storage and real-time processing.

Core Features & Use Cases

  • Partitioned ais_messages table with monthly partitions to enable efficient time-based queries.
  • Optimized vessels and analysis_summaries schemas for fast lookups and analytics.
  • Dedicated AIS database connection guidance for Laravel or raw SQL workflows.

Quick Start

  1. Ensure PostgreSQL 15+ is available.
  2. Create the AIS database and user with appropriate permissions.
  3. Apply the provided migrations or SQL scripts to initialize ais_messages partitions, vessels, and analysis_summaries tables.

Frequently Asked Questions about ais-database

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

FAQPage Schema
How do I set up a PostgreSQL database schema for AIS maritime data?▼

To set up a PostgreSQL database schema for AIS maritime data, apply the provided migrations to create partitioned ais_messages, vessels, and analysis_summaries tables. This schema requires PostgreSQL 15+ for native partitioning and JSONB support.

What is the best way to store real-time AIS data in PostgreSQL for efficient time-based queries?▼

The best way to store real-time AIS data in PostgreSQL is using a partitioned ais_messages table with monthly partitions. This approach optimizes time-based queries and real-time processing by isolating data into manageable monthly chunks.

Can I use Laravel migrations to manage an AIS PostgreSQL database connection?▼

Yes, you can use Laravel migrations to manage an AIS PostgreSQL database. The schema requires strict adherence to a dedicated 'ais' connection for both storage and migrations, and provides guidance for Laravel or raw SQL workflows.

Do I need PostgreSQL 15+ to handle AIS data partitioning and JSONB?▼

Yes, you need PostgreSQL 15+ to handle AIS data partitioning and JSONB usage. The schema relies on advanced PostgreSQL 15+ features to enable efficient monthly partitioning of ais_messages and JSONB storage for maritime data.

How does partitioning improve AIS data storage and lookups in PostgreSQL?▼

Partitioning improves AIS data storage by creating monthly partitions for ais_messages, enabling efficient time-based queries. It also uses optimized schemas for vessels and analysis_summaries to ensure fast lookups and high-speed analytics.

What tables are required for an AIS maritime data workflow in PostgreSQL?▼

An AIS maritime data workflow in PostgreSQL requires three primary tables: partitioned ais_messages for raw data, vessels for fast lookups, and analysis_summaries for analytics. These tables are initialized using the provided SQL scripts.

Related Skills

Explore More Software Engineering Skills→
siondwsiondw

supabase-queries

Run SQL queries against Supabase tables to inspect contest and user data.

Community
Intermediate
personamanagmentlayerpersonamanagmentlayer
41

maritime-expert

Monitor vessel movements via AIS and manage port operations.

Official
Advanced
victorhramos-devvictorhramos-dev

ais-parser-python

Decode AIS/NMEA sentences into structured JSON via a PHP-Python bridge.

Community
Intermediate
ShunmeiChoShunmeiCho
2

timescaledb

Deploy TimescaleDB on PostgreSQL and apply hypertables, compression, and continuous aggregates.

Community
Advanced