Changelog

Query History, RLS Policy Viewer & AI Security Analysis

New & Improved:

Database Tab

• First table is now automatically selected when navigating to the database tab
• Selecting a table from the sidebar no longer auto-switches to the Data panel

Query History

• Query history is now filtered by the currently selected table
• Added batch delete functionality with checkbox selection
• Queries now store the target table for better organization

RLS Policy Viewer (New)

• All-new Row Level Security (RLS) policy viewer as a sub-tab within the Database dashboard
• Displays RLS policies with security analysis (Secure/Review Needed/Risky)
• Policies sorted by security level, showing most critical first
• Security status display with color-coded scores (0-100) and descriptions
• AI-powered security analysis with actionable fix suggestions
• AI analysis inline with security status row with subtle green glow
• Fix suggestions include priority levels (P1-P10), categories, impact descriptions, and implementation steps

AI Assistant

• AI query assistant now focuses exclusively on the currently selected table

Fixes:

• Removed duplicate "Rerun" button in query history entries
• Fixed RLS badge logic to show worst security level across USING and CHECK clauses

Technical:

• Added target_table column to query_history table
• New API endpoints: /api/rls, /api/rls/analyze, /api/rls/fix-policy

Database Query Builder & Saved Queries

New & Improved:

Database Tab (New)

• Visual query builder with drag-and-drop table joining
• AI-powered SQL assistant for natural language queries
• SQL editor with syntax highlighting and execution
• Data browser with pagination, filtering, and sorting
• Schema viewer for exploring table structures

Saved Queries

• Save, organize, and reuse queries across sessions
• Support for AI, SQL, and Visual query types
• Team-shared queries with role-based access
• Cached query results for faster performance

Query History

• Complete log of all query executions
• Rerun historical queries with one click
• Track execution time and row counts

Technical:

• New tables: saved_queries, query_history
• Query cleanup functions to manage history limits
• RLS policies for team-based query sharing

Alerts & Notification Channels

New & Improved:

Alerts Dashboard (New)

• Real-time alerting for database health and performance metrics
• Threshold-based alerts (gt, lt, percentage change)
• Alert history with acknowledgment workflow
• Cooldown periods to prevent alert fatigue

Notification Channels

• Email notifications
• Slack integration with webhook support
• Discord integration for team alerts
• Multi-channel alert routing

Alert Rules

• Metric types: database size, cache hit ratio, active connections, query duration
• Customizable thresholds per metric
• Rule-specific channel assignments

Technical:

• New tables: alert_rules, alert_channels, alert_rule_channels, alert_state, alert_history
• OAuth2 flow for Slack and Discord
• Alert evaluation engine with cooldowns

Teams, Subscriptions & RBAC

New & Improved:

Teams (New)

• Create and manage teams for collaboration
• Invite members with role-based access (Owner, Admin, Member, Viewer)
• Team-based billing and resource sharing
• Team activity tracking

Subscriptions & Billing

• Integration with Polar.sh for subscription management
• Free, Pro, and Team tiers
• Usage-based tracking for metered features
• Subscription upgrade and downgrade flows

Role-Based Access Control (RBAC)

• Granular permissions per role
• Team-level resource isolation
• Audit logging for compliance

Compliance Tab (Team plan)

• Complete audit log of all user actions
• Access history and data governance reports
• Export compliance reports

Technical:

• New tables: subscriptions, teams, team_members, team_invites, audit_logs, usage_tracking
• Helper functions: get_user_plan(), get_team_role(), increment_usage()
• Comprehensive RLS policies for data isolation

Auth Analytics & Database Health

New & Improved:

Auth Dashboard

• User authentication metrics and trends
• Auth method breakdown (email, OAuth, magic links)
• User registration and login analytics
• Recent activity feed

Health Dashboard (New)

• Database size and growth tracking
• Cache hit ratio monitoring
• Active connections tracking
• Query performance metrics
• Resource utilization charts

Fixes:

• Mobile view UI improvements
• Dark mode refinements

Initial Release

Features:

Dashboard

• Project overview and quick stats
• Multi-project management
• OAuth2 integration with Supabase

Authentication

• Sign up / Sign in flows
• Social login providers (Google, GitHub, etc.)
• Session management with secure token storage
• OAuth2 token refresh mechanism

Database Connectivity

• Connect and manage Supabase projects
• Secure token management with encryption
• Project sync and validation

UI/UX

• Dark mode support
• Mobile-responsive design
• Minimalist interface with consistent styling

Security

• Client-side encryption for access tokens
• Secure API routes with authentication
• Rate limiting and abuse prevention
• Audit logging foundation

Technical Stack:

• Next.js 15 with App Router
• Supabase for authentication and database
• Recharts for data visualization
• RemixIcon for iconography
• Tailwind CSS for styling