> ## Documentation Index > Fetch the complete documentation index at: https://tigerdata-747200db-chore-custom-colored-homepage.mintlify.site/llms.txt > Use this file to discover all available pages before exploring further. # Create a cloud service > Tiger Cloud offers a range of capabilities to accommodate your real-time analytics and AI and vector workloads. Learn more about each of them and create your first service in Tiger Cloud Console export const TIMESCALE_DB = 'TimescaleDB'; export const MST_SHORT = 'MST'; export const MST_LONG = 'Managed Service for TimescaleDB'; export const MST_CONSOLE_LONG = 'MST Console'; export const MST_CONSOLE_SHORT = 'MST Console'; export const MST_SERVICE_SHORT = 'MST service'; export const VPC = 'VPC'; export const OPS_MODE_CAP = 'Ops mode'; export const DATA_MODE = 'data mode'; export const OPS_MODE = 'ops mode'; export const ACCOUNT_LONG = 'Tiger Cloud account'; export const CONSOLE = 'Tiger Cloud Console'; export const READ_REPLICA = 'read replica'; export const HYPERCORE = 'hypercore'; export const COLUMNSTORE = 'columnstore'; export const CAGG = 'continuous aggregate'; export const HYPERTABLE = 'hypertable'; export const SERVICE_SHORT = 'service'; export const TIGER_POSTGRES = 'Tiger Postgres'; export const PG = 'Postgres'; export const CLOUD_LONG = 'Tiger Cloud'; export const SERVICE_LONG = 'Tiger Cloud service'; export const COMPANY = 'TigerData'; export const TIMESCALE_DB_0 = undefined export const PRICING_PLAN_0 = undefined {CLOUD_LONG} is the modern {PG} data platform for all your applications. It enhances {PG} to handle time series, events, real-time analytics, and vector search—all in a single database alongside transactional workloads. You get one system that handles live data ingestion, late and out-of-order updates, and low latency queries, with the performance, reliability, and scalability your app needs. Ideal for IoT, crypto, finance, SaaS, and a myriad other domains, {CLOUD_LONG} allows you to build data-heavy, mission-critical apps while retaining the familiarity and reliability of {PG}. A {SERVICE_LONG} is a single optimised instance of {TIGER_POSTGRES}. {TIGER_POSTGRES} is {PG} extended with innovations in the database engine and cloud infrastructure to deliver speed without compromise. A {SERVICE_LONG} instance is 10-1000x faster at scale! A {SERVICE_SHORT} is ideal for applications requiring strong data consistency, complex relationships, and advanced querying capabilities. Get ACID compliance, extensive SQL support, JSON handling, and extensibility through custom functions, data types, and extensions. To the {PG} you know and love, {TIGER_POSTGRES} adds the following capabilities: * **Real-time analytics**: store and query [time-series data][what-is-time-series] at scale for real-time analytics and other use cases. Get faster time-based queries with {HYPERTABLE}s, {CAGG}s, and columnar storage. Save money by compressing data into the {COLUMNSTORE}, moving cold data to low-cost bottomless storage in Amazon S3, and deleting old data with automated policies. * **AI-focused**: build AI applications from start to scale. Get fast and accurate similarity search with the pgvector and pgvectorscale extensions. Create vector embeddings and perform LLM reasoning on your data with the pgai extension. * **Hybrid applications**: get a full set of tools to develop applications that combine time-based data and AI. All {SERVICE_LONG}s include the tooling you expect for production and developer environments: [live migration][live-migration], [automatic backups and PITR][automatic-backups], [high availability][high-availability], [{READ_REPLICA}s][readreplica], [data forking][operations-forking], [connection pooling][connection-pooling], [tiered storage][data-tiering], [usage-based storage][how-plans-work], secure in-{CONSOLE} [SQL editing][in-console-editors], {SERVICE_SHORT} [metrics][metrics] and [insights][insights], [streamlined maintenance][maintain-upgrade], and much more. {CLOUD_LONG} continuously monitors your {SERVICE_SHORT}s and prevents common {PG} out-of-memory crashes. [what-is-time-series]: https://www.timescale.com/blog/time-series-database-an-explainer#what-is-a-time-series-database [create-service]: /cloud/get-started/create-services [live-migration]: /migrate/live-migration/ [automatic-backups]: /use-timescale/backup-restore/ [high-availability]: /use-timescale/ha-replicas/high-availability/ [readreplica]: /use-timescale/ha-replicas/read-scaling/ [operations-forking]: /use-timescale/services/service-management/#fork-a-service [connection-pooling]: /use-timescale/services/connection-pooling [data-tiering]: /use-timescale/data-tiering/ [how-plans-work]: /about/pricing-and-account-management/#how-plans-work [in-console-editors]: /getting-started/run-queries-from-console/ [metrics]: /use-timescale/metrics-logging/monitoring/#metrics [insights]: /use-timescale/metrics-logging/monitoring/#insights [maintain-upgrade]: /use-timescale/upgrades/ You manage your {SERVICE_LONG}s and interact with your data in CONSOLE using the following modes: [ops-mode]: https://assets.timescale.com/docs/images/tiger-cloud-console/ops-mode-overview-tiger-cloud.png [data-mode]: https://assets.timescale.com/docs/images/tiger-cloud-console/tiger-cloud-data-mode.png To start using {CLOUD_LONG} for your data: 1. [Create a {ACCOUNT_LONG}][create-an-account]: register to get access to {CONSOLE} as a centralized point to administer and interact with your data. 2. [Create a {SERVICE_LONG}][create-a-service]: that is, a {PG} database instance, powered by [{TIMESCALE_DB_0}][timescaledb], built for production, and extended with cloud features like transparent data tiering to object storage. 3. [Connect to your {SERVICE_LONG}][connect-to-your-service]: to run queries, add and migrate your data from other sources. ## Create a {ACCOUNT_LONG} You create a {ACCOUNT_LONG} to manage your {SERVICE_SHORT}s and data in a centralized and efficient manner in {CONSOLE}. From there, you can create and delete {SERVICE_SHORT}s, run queries, manage access and billing, integrate other services, contact support, and more. You create a standalone account to manage {CLOUD_LONG} as a separate unit in your infrastructure, which includes separate billing and invoicing. To set up {CLOUD_LONG}: 1. **Sign up for a 30-day free trial** Open [Sign up for {CLOUD_LONG}][timescale-signup] and add your details, then click `Start your free trial`. You receive a confirmation email in your inbox. 2. **In the confirmation email, click the link supplied and sign in to [{CONSOLE}][tsc-portal]** 3. **Answer the requirements questions** Your answers help us optimize {SERVICE_LONG}s for your use cases. To have {CLOUD_LONG} as a part of your AWS infrastructure, you create a {ACCOUNT_LONG} through AWS Marketplace. In this case, {CLOUD_LONG} is a line item in your AWS invoice. To set up {CLOUD_LONG} via AWS: 1. **Open [AWS Marketplace][aws-marketplace] and search for `Tiger Cloud`** You see two pricing options, [pay-as-you-go][aws-paygo] and [annual commit][aws-annual-commit]. 2. **Select the pricing option that suits you and click `View purchase options`** 3. **Review and configure the purchase details, then click `Subscribe`** 4. **Click `Set up your account` at the top of the page** You are redirected to {CONSOLE}. 5. **Sign up for a 30-day free trial** Add your details, then click `Start your free trial`. If you want to link an existing {ACCOUNT_LONG} to AWS, log in with your existing credentials. 6. **In `Confirm AWS Marketplace connection`, click `Connect`** Your {CLOUD_LONG} and AWS accounts are now connected. 7. **Answer the requirements questions** Your answers help us optimize {SERVICE_LONG}s for your use cases. [tsc-portal]: https://console.cloud.timescale.com/ [timescale-website]: https://www.timescale.com/ [aws-marketplace]: https://aws.amazon.com/marketplace [aws-paygo]: https://aws.amazon.com/marketplace/pp/prodview-iestawpo5ihca?applicationId=AWSMPContessa&ref_=beagle&sr=0-1 [aws-annual-commit]: https://aws.amazon.com/marketplace/pp/prodview-ezxwlmjyr6x4u?applicationId=AWSMPContessa&ref_=beagle&sr=0-2 [timescale-signup]: https://console.cloud.timescale.com/signup ## Create a {SERVICE_LONG} Now that you have an active {ACCOUNT_LONG}, you create and manage your {SERVICE_SHORT}s in {CONSOLE}. When you create a {SERVICE_SHORT}, you effectively create a blank {PG} database with additional {CLOUD_LONG} features available under your {PRICING_PLAN_0}. You then add or migrate your data into this database. 1. In the [{SERVICE_SHORT} creation page][create-service], choose the capability to match your business needs: `Real-time analytics`, `AI-focused`, or `Hybrid applications`. ![Create a SERVICE\_LONG](https://assets.timescale.com/docs/images/tiger-cloud-console/create-tiger-cloud-service.png) 1. Follow the next steps in `Create a service` to configure the region, compute size, environment, availability, connectivity, and {SERVICE_SHORT} name. Then click `Create service`. Your {SERVICE_SHORT} is constructed and ready to use in a few seconds. 1. Click `Download the config` and store the configuration information you need to connect to this {SERVICE_SHORT} in a secure location. This file contains the passwords and configuration information you need to connect to your {SERVICE_SHORT} using the {CONSOLE} {DATA_MODE}, from the command line, or using third-party database administration tools. If you choose to go directly to the {SERVICE_SHORT} overview, [Connect to your {SERVICE_SHORT}][connect-to-your-service] shows you how to connect. ## Connect to your {SERVICE_SHORT} To run queries and perform other operations, connect to your {SERVICE_SHORT}: 1. **Check your {SERVICE_SHORT} is running correctly** In [{CONSOLE}][services-portal], check that your {SERVICE_SHORT} is marked as `Running`. ![Check SERVICE\_SHORT is running](https://assets.timescale.com/docs/images/tiger-cloud-console/tiger-cloud-console-services-view.png) 2. **Connect to your {SERVICE_SHORT}** Connect using data mode or SQL editor in {CONSOLE}, or psql in the command line: 1. In {CONSOLE}, toggle `Data`. 2. Select your {SERVICE_SHORT} in the connection drop-down in the top right. ![Select a connection](https://assets.timescale.com/docs/images/tiger-cloud-console/tiger-cloud-data-mode-connection-dropdown.png) 3. Run a test query: ```sql SELECT CURRENT_DATE; ``` This query gives you the current date, you have successfully connected to your {SERVICE_SHORT}. And that is it, you are up and running. Enjoy developing with {COMPANY}. 1. In {CONSOLE}, select your {SERVICE_SHORT}. 2. Click `SQL editor`. ![Check a SERVICE\_SHORT is running](https://assets.timescale.com/docs/images/tiger-cloud-console/tiger-cloud-ops-mode-sql-editor.png) 3. Run a test query: ```sql SELECT CURRENT_DATE; ``` This query gives you the current date, you have successfully connected to your {SERVICE_SHORT}. And that is it, you are up and running. Enjoy developing with {COMPANY}. 1. Install [psql][psql]. 2. Run the following command in the terminal using the service URL from the config file you have saved during service creation: ``` psql "" ``` 3. Run a test query: ```sql SELECT CURRENT_DATE; ``` This query returns the current date. You have successfully connected to your {SERVICE_SHORT}. And that is it, you are up and running. Enjoy developing with {COMPANY}. Quick recap. You: * Manage your {SERVICE_SHORT}s in the [{OPS_MODE}][portal-ops-mode] in {CONSOLE}: add {READ_REPLICA}s and enable high availability, compress data into the {COLUMNSTORE}, change parameters, and so on. * Analyze your data in the [{DATA_MODE}][portal-data-mode] in {CONSOLE}: write queries with autocomplete, save them in folders, share them, create charts/dashboards, and much more. * Store configuration and security information in your config file. [portal-ops-mode]: https://console.cloud.timescale.com/dashboard/services [portal-data-mode]: https://console.cloud.timescale.com/dashboard/services?popsql [account-portal]: https://console.cloud.timescale.com/dashboard/account [services-portal]: https://console.cloud.timescale.com/dashboard/services [install-psql]: /integrations/psql/ [popsql]: /getting-started/run-queries-from-console/#data-mode [run-sqleditor]: /getting-started/run-queries-from-console/#sql-editor [install-psql]: /integrations/psql/ [hypertables]: /use-timescale/hypertables/#hypertable-partitioning [psql]: /integrations/psql/ What next? [Try the key features offered by {COMPANY}][try-timescale-features], see the [tutorials][tutorials], interact with the data in your {SERVICE_LONG} using [your favorite programming language][connect-with-code], integrate your {SERVICE_LONG} with a range of [third-party tools][integrations], plain old [Use {COMPANY} products][use-timescale], or dive into the [API reference][use-the-api]. [tutorials]: /tutorials/ [integrations]: /integrations/ [connect-with-code]: /getting-started/start-coding-with-timescale/ [use-the-api]: /api/ [use-timescale]: /use-timescale/ [try-timescale-features]: /getting-started/try-key-features-timescale-products/ [tsc-portal]: https://console.cloud.timescale.com/ [services-how-to]: /use-timescale/services/ [install-psql]: /integrations/psql/ [create-an-account]: /getting-started/services/#create-a-timescale-cloud-account [create-a-service]: /getting-started/services/#create-a-timescale-cloud-service [connect-to-your-service]: /getting-started/services/#connect-to-your-service [create-a-hypertable]: /getting-started/services/#create-a-hypertable [create-service]: https://console.cloud.timescale.com/dashboard/create_services [what-is-time-series]: https://www.timescale.com/blog/what-is-a-time-series-database/#what-is-a-time-series-database [what-is-dynamic-postgres]: https://www.timescale.com/dynamic-postgresql [hypertables]: /use-timescale/hypertables/#hypertable-partitioning [timescaledb]: https://docs.tigerdata.com/#TimescaleDB {MST_LONG} ({MST_SHORT}) is [{TIMESCALE_DB}][github-timescle-db] hosted on Azure and GCP. {MST_SHORT} is offered in partnership with Aiven. [github-timescle-db]: https://github.com/timescale/timescaledb {CLOUD_LONG} is a high-performance developer focused cloud that provides {PG} services enhanced with our blazing fast vector search. You can securely integrate {CLOUD_LONG} with your AWS, GCS or Azure infrastructure. [Create a {SERVICE_LONG}][timescale-service] and try for free. If you need to run {TIMESCALE_DB} on GCP or Azure, you're in the right place — keep reading. [timescale-service]: /getting-started/:currentVersion:/services ## Create your first service A {MST_SERVICE_SHORT} in {MST_LONG} is a cloud instance on your chosen cloud provider, which you can install your database on. ### Creating your first {MST_SERVICE_SHORT} 1. \[Sign in]\[mst-login] to your {MST_CONSOLE_LONG}. 2. Click `Create service` and choose `TimescaleDB`, and update your preferences: Create a new service in the Managed Service for TimescaleDB portal * In the `Select Your Cloud Service Provider` field, click your preferred provider. * In the `Select Your Cloud Service Region` field, click your preferred server location. This is often the server that's physically closest to you. * In the `Select Your Service Plan` field, click your preferred plan, based on the hardware configuration you require. If you are in your trial period, and just want to try the {MST_SERVICE_SHORT} out, or develop a proof of concept, we recommend the `Dev` plan, because it is the most cost-effective during your trial period. 1. In the information bar on the right of the screen, review the settings you have selected for your {MST_SERVICE_SHORT}, and click `Create Service`. The {MST_SERVICE_SHORT} takes a few minutes to provision. ## Connect to your {MST_SERVICE_SHORT} from the command prompt When you have a {MST_SERVICE_SHORT} up and running, you can connect to it from your local system using the `psql` command-line utility. This is the same tool you might have used to connect to {PG} before, but if you haven't installed it yet, check out the \[installing psql]\[install-psql] section. 1. \[Sign in]\[mst-login] to your {MST_CONSOLE_SHORT}. 2. In the `Services` tab, find the {MST_SERVICE_SHORT} you want to connect to, and check it is marked as `Running`. 3. Click the name of the {MST_SERVICE_SHORT} you want to connect to see the connection information. Take a note of the `host`, `port`, and `password`. 4. On your local system, at the command prompt, connect to the {MST_SERVICE_SHORT}, using your own {MST_SERVICE_SHORT} details: ```bash psql -x "postgres://tsdbadmin:@:/defaultdb?sslmode=require" ``` If your connection is successful, you'll see a message like this, followed by the `psql` prompt: ```bash psql (13.3, server 13.4) SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, bits: 256, compression: off) Type "help" for help. defaultdb=> ``` ## Check that you have the {TIMESCALE_DB} extension {TIMESCALE_DB} is provided as an extension to your {PG} database, and it is enabled by default when you create a new service on {MST_LONG} You can check that the {TIMESCALE_DB} extension is installed by using the `\dx` command at the `psql` prompt. It looks like this: ```sql defaultdb=> \dx List of installed extensions -[ RECORD 1 ]------------------------------------------------------------------ Name | plpgsql Version | 1.0 Schema | pg_catalog Description | PL/pgSQL procedural language -[ RECORD 2 ]------------------------------------------------------------------ Name | timescaledb Version | 2.5.1 Schema | public Description | Enables scalable inserts and complex queries for time-series data defaultdb=> ``` ## Where to next Now that you have your first service up and running, you can check out the \[{MST_LONG}]\[mst-docs] section in the documentation, and find out what you can do with it. If you want to work through some tutorials to help you get up and running with {TIMESCALE_DB} and time-series data, check out the \[tutorials]\[tutorials] section. You can always \[contact us]\[contact] if you need help working something out, or if you want to have a chat.