SQL Editor and Viewer

Powered by: EMG

Contains ads

About this app

SQL Editor and Viewer is a powerful, professional-grade database management tool designed for your Android device. Whether you are a developer, database administrator, student, or data enthusiast, this app gives you everything you need to open, browse, edit, and manage SQLite database files right from your phone or tablet.

★ OPEN ANY DATABASE FILE
Support for .db, .sqlite, and .sql file formats. Use the built-in file explorer powered by Android Storage Access Framework (SAF) to browse and open database files from anywhere on your device, including internal storage, external SD cards, and cloud storage providers. Your recent files are tracked for quick access.

★ POWERFUL SQL EDITOR
Write and execute SQL queries with a full-featured editor that includes syntax highlighting, auto-complete suggestions, and multi-tab support. Save your favorite queries as bookmarks for quick reuse. Access your complete query history to revisit previous commands. Execute any SQL statement — SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, DROP, and more.

★ TABLE VIEWER & DATA BROWSER
View your database tables in a clean, scrollable grid with professional formatting. Sort columns in ascending or descending order with a single tap. Filter and search through your data instantly. Zoom in and out for comfortable viewing. Navigate through large datasets with smooth scrolling performance.

★ FULL CRUD OPERATIONS
Create, read, update, and delete records directly from the table viewer. Add new rows, edit existing data, and remove records with an intuitive interface. All changes are tracked with a built-in undo/redo system so you never lose your work.

★ SCHEMA BROWSER & TABLE MANAGEMENT
Explore your database structure with a comprehensive schema browser. View all tables, columns, data types, primary keys, and constraints at a glance. Create new tables with an easy-to-use wizard — define columns, set data types, mark primary keys, and configure constraints without writing SQL. Drop or rename tables as needed.

★ EXPORT & IMPORT DATA
Export your tables and query results in multiple formats including CSV, JSON, and SQL. Import data from external sources. Share exported files via email, messaging apps, or cloud storage. Perfect for data backup, migration, and sharing.

★ CREATE NEW DATABASES
Start from scratch by creating brand new SQLite databases. Build your table structure, define your schema, and populate data — all within the app.

★ DATABASE STATISTICS
View detailed statistics about your database including table count, total row counts, database file size, and per-table row counts. Get a quick overview of your entire database structure.

★ FOREIGN KEY VISUALIZATION
Understand your database relationships with a visual foreign key diagram. See how tables connect to each other through foreign key constraints, making it easy to understand complex database schemas.

★ BLOB DATA & IMAGE PREVIEW
View binary large object (BLOB) data stored in your database. Preview images stored as BLOB data directly within the app without any external tools.

★ ADVANCED FEATURES
• Undo/Redo System — Track and reverse all your changes with unlimited undo and redo
• Read-Only Mode — Open databases in read-only mode to prevent accidental modifications
• Recent Files — Quick access to your recently opened database files
• Dark & Light Themes — Choose between dark mode and light mode with Material Design 3 styling
• Modern UI — Clean, intuitive interface following Material You design guidelines

★ WHO IS THIS APP FOR?
• Mobile developers debugging SQLite databases
• Database administrators managing data on the go
• Students learning SQL and database concepts
• Data analysts examining database contents
• Anyone who needs to view or edit SQLite files on Android

SQL Editor and Viewer puts the power of a desktop database management tool into your pocket. Download now and take full control of your SQLite databases!