# Poge

## Docs

- [API Overview](https://docs.poge.dev/api/introduction.md): Introduction to Poge API endpoints for PostgreSQL operations
- [Query Execution](https://docs.poge.dev/api/query-execution.md): Execute SQL queries with automatic transaction handling
- [Schema Operations](https://docs.poge.dev/api/schema-operations.md): Retrieve database schema tree structure
- [Statistics](https://docs.poge.dev/api/statistics.md): Connection pool and query cache statistics endpoints
- [Table Operations](https://docs.poge.dev/api/table-operations.md): Fetch paginated table data with sorting and column metadata
- [Test Connection](https://docs.poge.dev/api/test-connection.md): Verify PostgreSQL database credentials and connectivity
- [Database Object Types](https://docs.poge.dev/api/types/database-objects.md): TypeScript interfaces for database schema, tables, columns, and definitions
- [Query Result Types](https://docs.poge.dev/api/types/query-results.md): TypeScript interfaces for query execution, results, and saved queries
- [Server Connection Types](https://docs.poge.dev/api/types/server-connection.md): TypeScript interfaces for PostgreSQL server connections
- [Data export and import](https://docs.poge.dev/features/data-export-import.md): Export table data to CSV, JSON, or Excel formats, and import data with encrypted backups
- [Notes and history](https://docs.poge.dev/features/notes-and-history.md): Keep track of your queries, save notes, and access your query history across sessions
- [Query tool](https://docs.poge.dev/features/query-tool.md): Write and execute SQL queries with syntax highlighting, multi-statement support, and automatic query history
- [Schema explorer](https://docs.poge.dev/features/schema-explorer.md): Navigate your database structure with an interactive tree view of databases, schemas, tables, and views
- [Table viewer](https://docs.poge.dev/features/table-viewer.md): Browse, edit, and manage table data with pagination, filtering, and export capabilities
- [Installation](https://docs.poge.dev/installation.md): Deploy Poge to Vercel, use the hosted version, or run it locally
- [Introduction](https://docs.poge.dev/introduction.md): A lightweight PostgreSQL database management tool that runs entirely in your browser with a local-first architecture
- [Quickstart](https://docs.poge.dev/quickstart.md): Get up and running with Poge in under 5 minutes
- [Changelog](https://docs.poge.dev/resources/changelog.md): Version history and release notes for Poge
- [Keyboard Shortcuts](https://docs.poge.dev/resources/keyboard-shortcuts.md): Complete list of keyboard shortcuts in Poge
- [Troubleshooting](https://docs.poge.dev/resources/troubleshooting.md): Common issues and solutions for Poge
- [Encryption](https://docs.poge.dev/security/encryption.md): Technical details of AES-256-GCM encryption, key derivation, and encrypted backup format in Poge
- [Security Overview](https://docs.poge.dev/security/overview.md): Understand Poge's local-first security model, encryption architecture, and best practices for protecting your database credentials
- [Session Management](https://docs.poge.dev/security/session-management.md): Configure PIN protection, auto-lock timeouts, session expiration, and learn how to change your security PIN
- [Backup & Restore](https://docs.poge.dev/self-hosting/backup-restore.md): Backup strategies, encrypted exports, and migration between Poge instances
- [Configuration](https://docs.poge.dev/self-hosting/configuration.md): Configure your Poge instance, Next.js settings, and SSL/TLS for database connections
- [Deployment](https://docs.poge.dev/self-hosting/deployment.md): Deploy Poge to Vercel, Netlify, Railway, or your own infrastructure