Recipes

Implement semantic image search using vector embeddings and similarity functions

Build intelligent document search using text embeddings for meaning-based retrieval

Transcribe audio content and analyze transcripts with AI functions

Extract metadata, scenes, and insights from video content using AI functions

Search across images, videos, audio, and documents using unified vector search

Build a recommendation system using vector similarity and user behavior

Create automated media processing pipelines with status tracking and notifications

Build comprehensive analytics for media usage, engagement, and performance

Track media compliance, retention policies, and audit trails for governance

Synchronize media assets across multiple platforms and track sync status

Create a simple table for MP3 audio files with essential metadata for audio file management

Store audio files in multiple formats including MP3, WAV, FLAC, AAC, and OGG for comprehensive audio management

Store podcast episodes with show relationships for building a complete podcast management system

Create a music library with artist and album relationships for comprehensive music management

Query audio files by duration using the DURATION function for filtering and analytics

Store voice memos and recordings with timestamps for personal and business voice note management

Transcribe audio files using the TRANSCRIBE function for searchable audio content

Search podcast content via transcribed text for discovering episodes by spoken content

Organize audiobook chapters with sequential ordering for complete audiobook library management

Store customer service call recordings with metadata for compliance and quality assurance

Create playlists with ordered audio tracks for music and podcast playlist management

Catalog sound effects with categories and tags for game development and media production

Find similar audio files using embeddings generated from audio content descriptions

Store meeting recordings with attendee metadata for corporate meeting management

Store audio files with detected language from transcription for multilingual content management

Create your first AIDB table with basic data types - the essential starting point for learning AIDB SQL

Create a table using all standard SQL types including INTEGER, VARCHAR, BOOLEAN, DECIMAL, and more

Create a table with AUDIO, VIDEO, IMAGE, and PDF columns for storing rich media content

Create a table with VECTOR type for storing embeddings and enabling similarity search

Create tables with PRIMARY KEY, UNIQUE, NOT NULL, and CHECK constraints for data integrity

Create related tables with FOREIGN KEY constraints to establish referential integrity

Create tables with DEFAULT values for automatic population of columns

Create tables with JSON and JSONB columns for flexible metadata and semi-structured data storage

Create tables using UUID for distributed-friendly unique identifiers instead of sequential integers

Create tables with created_at and updated_at timestamp columns for automatic record tracking

A comprehensive recipe for building a point of sales system using SynapCores database.

This recipe provides the necessary database schema for a comprehensive Customer Relationship Management (CRM) system.

Quit demo to show the capabilities of IMMUTABLE tables and security features!

Store and manage PDF documents with metadata for document management systems

Extract and search text content from PDF documents using AI

Process multi-page PDF documents with page-level metadata and content tracking

Use vector embeddings for semantic document search and similarity matching

Extract and store structured data from invoice PDF documents

Store and manage legal documents with contract tracking and compliance features

Track document versions with change history and revision management

Manage contracts with parties, terms, obligations, and renewal tracking

Store and search candidate resumes with skills extraction and matching

Store research papers with citations, authors, and semantic search capabilities

Automatically classify documents into categories using AI and rule-based systems

Extract structured data from PDF forms including fields, values, and validation

Manage document approval workflows with routing, tasks, and audit trails

Build a searchable knowledge base from PDF documents using AI embeddings

Track document compliance requirements with retention policies and audit trails

Manage product images with multiple views, variants, and quality levels for e-commerce

Manage product demonstration videos with timestamps and feature highlights

Manage customer reviews with photos and ratings for social proof

Manage brand assets including logos, guidelines, and marketing materials

Create and manage product comparison visuals for helping customers decide

Manage seasonal promotions, campaign banners, and marketing visuals

Create visual size guides with measurement images and fit recommendations

Store and manage product images for virtual try-on and AR visualization

Manage 360-degree spin photography for interactive product viewing

Manage unboxing videos showing product packaging and first impressions

Organize and manage educational course videos with chapters, transcripts, and progress tracking

Manage university lecture recordings with scheduling, multi-camera capture, and searchable transcripts

Manage multimedia student assignment submissions with versioning and feedback

Manage presentation slides with versioning, annotations, and student notes

Create multimedia quizzes with images, audio, and video questions

Manage online class recordings with breakout rooms, chat logs, and participant tracking

Build a comprehensive multimedia learning resource library with categorization and recommendations

Manage employee training content with completion tracking and certification

Organize marketing assets across campaigns with versioning, approvals, and usage tracking

Archive and search corporate communications including memos, announcements, and recordings

Manage technical product documentation with versioning, localization, and feedback

Manage legal contracts, agreements, and compliance documents with expiration tracking

Manage brand guidelines, logos, and visual identity assets with usage rules

Manage new hire onboarding content including videos, documents, and checklists

Archive and search corporate meeting recordings with transcripts and action items

Build a 6-person social graph and find friends-of-friends with a single Cypher pattern match

Traverse a 4-level reporting hierarchy with variable-length paths to list every direct and indirect report

Recommend movies a user has not seen by traversing watched-movies and shared-genre patterns

Build an order-product-customer graph and surface the top items frequently bought with a target product

Use weighted edges and mutual-friend counts to suggest new connections ranked by tie strength

Detect circular money-laundering patterns up to length 4 by finding cycles in a transaction graph

Trace which products and customers are affected if a critical vendor goes offline

Flag dangerous drug combinations across all patients via a prescribed-drug interaction graph

Resolve what a user can actually do by walking user-group-role-permission graph paths

Topologically order a software dependency graph and find the longest critical path

Rank papers by citation influence using a multi-hop weighted graph traversal

Cluster duplicate customer records that share emails, phones, or addresses across systems

Surface multi-hop transaction chains that obscure source-of-funds, longer than 3 hops with high values

Find every path from a public-facing asset to crown-jewel systems through chained vulnerabilities

Answer multi-hop natural-language questions by traversing a small entity graph

Combine SIMILAR_TO vector hops with structural patterns to answer questions vector-only RAG can't

Send a paragraph of a CFO call to /v2/graph/extract and query the resulting entity graph

Extract parties, obligations, and dates from contract text, then have LLM_SCORE flag risky clauses

Recommend "products like this" by walking SIMILAR_TO over embedding properties on Product nodes

Build a long-term episodic memory graph for an LLM agent, recall by semantic + structural patterns

Match candidates to roles with structural skill hits plus semantic similarity and an LLM fit score

Catch duplicate customers whose emails differ but whose name + address embed alike

Cluster IOCs and actors across feeds by extracting from advisories and matching with SIMILAR_TO

Extract supplier-event edges from news prose and grade each event with LLM_SCORE

Walk drug-target-disease chains then use SIMILAR_TO on mechanism embeddings to find candidates

Extract entities from abstracts and cluster papers semantically with SIMILAR_TO

Combine connection-count centrality with LLM_SCORE for authenticity, surface real influencers

Walk transitive dependency edges and have the LLM judge if a CVE actually applies in your context

Use SIMILAR_TO over symptom embeddings on patient nodes to surface clinical lookalikes

Extract action items, owners, and dates from meeting minutes and rank urgency with LLM_SCORE

Store and manage medical images with patient records and metadata

Organize and manage radiographic X-ray images with views and annotations

Manage complex cross-sectional imaging studies with multiple sequences and reconstructions

Manage whole slide images for digital pathology and tissue analysis

Create and manage annotations, measurements, and findings on medical images

Track and query patient imaging studies over time for longitudinal analysis

Link radiology reports with images and extract structured findings

Analyze medical imaging data for operational insights and quality metrics

Create a simple photo storage table with JPEG images for building a basic gallery application

Store images in multiple formats including JPEG, PNG, WEBP, and GIF with format-specific columns

Store images with dimensions, file size, and EXIF data in JSON columns for rich metadata management

Create albums and photos tables with relationships for organizing images into collections

Implement a flexible tagging system for images using a junction table for many-to-many relationships

Store user profile pictures with thumbnail variants for efficient display at different sizes

Extract text from images using the EXTRACT_TEXT function for searchable image content

Query images by dimensions using the DIMENSIONS function for filtering by size and aspect ratio

Create embeddings for images to enable similarity search and visual content discovery

Store and organize application screenshots with metadata for bug tracking and documentation

Store multiple image sizes for e-commerce products including thumbnails, medium, and full-size variants

Convert images between formats using the CONVERT_FORMAT function for optimization and compatibility

Resize images using the RESIZE_IMAGE function for creating thumbnails and optimized variants

Store scanned documents as images with OCR text extraction for searchable document archives

Find similar images using vector cosine similarity for visual content discovery and deduplication

Train a simple regression model, deploy it, run predictions, then verify results match the known function.

Build a model to predict which customers are likely to churn based on their account characteristics and usage patterns.

Score incoming transactions for fraud risk in near real time. Block high-risk cases.

Triage scans into **urgent** vs **normal** using pre-computed metadata. Route urgent first.

Score compounds for likelihood of success. Prioritize top candidates for lab testing.

Build an intelligent real estate platform that matches buyers with properties, predicts market trends, analyzes property values, and generates insi...

Create intelligent marketing campaigns by analyzing customer behavior, segmenting audiences, predicting churn, and generating personalized content...

Analysis, and Media Processing This comprehensive demo showcases advanced AI-powered database capabilities through four key areas: Retrieval-Augmen...

Store and manage surveillance video footage from security cameras

Track and analyze motion detection events from surveillance cameras

Track access control events with badge photos and entry images

Store and query license plate recognition data from parking and security systems

Log and query facial recognition events for access control and security

Manage video evidence collection and chain of custody for security incidents

Manage security alerts, notifications, and response workflows

Store and retrieve MP4 video files with metadata for video content management

Store videos in multiple formats (MP4, AVI, MKV, WEBM, MOV) for cross-platform compatibility

Query and analyze video content by duration for content planning and scheduling

Extract and store video frames for thumbnails, previews, and image analysis

Extract and manage audio tracks from video files for transcription and analysis

Transcribe video content to text for searchability, subtitles, and accessibility

Add chapter markers to videos for enhanced navigation and content organization

Store multiple thumbnail images for video content with selection preferences

Organize videos into hierarchical categories with tags for content discovery

Manage video series with episodes, seasons, and sequential ordering

Build a platform for user-uploaded videos with moderation and engagement features

Track video views with detailed analytics including watch time and completion rates

Store multi-language subtitles and captions for video accessibility

Store multiple resolution versions of videos for adaptive streaming

Search video content using embeddings, transcripts, and metadata for intelligent discovery